You can use this part of the formula for the simple vlookup
COLUMN'=MATCH(TEXT($J$3,"MM/yy"),'2011 Actual'!$A$1:$X$1,0)
On Aug 20, 6:43 am, Steve Weaver wrote:
> Sam, thank you so much . . . the formula works GREAT!!!
>
> Steve
>
> On 8/20/2011 1:05 AM, GoldenLance wrote:
>
>
>
> > Use =INDIRECT(
I don't quite understand your need. Please explain "excluded". give examples
On Friday, September 21, 2012 10:37:34 AM UTC-5, rekha siri wrote:
>
> hi experts,
>
> please help me in this concern, i have data spread from A to AB columns
>
> from one of the column i want to apply filter select one r
Your sample does not result in a hit in col M for roy or rod.
On Friday, September 21, 2012 10:37:34 AM UTC-5, rekha siri wrote:
>
> hi experts,
>
> please help me in this concern, i have data spread from A to AB columns
>
> from one of the column i want to apply filter select one region in column
On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:
>
> Dear Group,
>
> When I mannualy enter the "C7" into the following formula, it has no
> problem,
>
> =SUMPRODUCT(($H$2:$H$9=$H13)*(*C7*))
>
> but when I am trying to generate C7, it's given me #value error, however
>
What you want is easy to do but I fail to see the LOGIC of what you want.
Explain...
On Friday, September 28, 2012 5:48:22 AM UTC-5, shrini wrote:
>
> Dear All
> Can Any one help me to write a macro for following things.
>
> In sheet 1 I have more than 200 items.I want to make a sample by c
Why bother when I gave you the PROPER formula.
On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:
>
> Dear Group,
>
> When I mannualy enter the "C7" into the following formula, it has no
> problem,
>
> =SUMPRODUCT(($H$2:$H$9=$H13)*(*C7*))
>
> but when I am trying to gene
what is wrong with what I posted much earlier
INDEX(C:C,MATCH($H12,$H:$H))
instead of this
=INDEX(C2,MATCH($H12,$H$2:$H$9,0))
if you insist on sumproduct, this will do just fine.
=SUMPRODUCT(($H$2:$H$9=$H12)*C$2:C$9)
On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:
>
> Dear G
I LOOKED at the provided file and gave proper
answers
including the "homework" question about sumproduct.
On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:
>
> Dear Group,
>
> When I mannualy enter the "C7" into the following formula, i
Methinks you are making this much more difficult than necessary.
Either fully explain what you want with before/after example
If all else fails, send file to dguillett1 @gmail.com
On Tuesday, October 2, 2012 4:33:57 PM UTC-5, Diamond Dave wrote:
>
> Attached is a file which contains a Macro (S
Provide a file with this to dguillett1 @gmail.com
On Friday, September 28, 2012 5:48:22 AM UTC-5, shrini wrote:
>
> Dear All
> Can Any one help me to write a macro for following things.
>
> In sheet 1 I have more than 200 items.I want to make a sample by choosing
> items from this list.
>
> 1
I have re read your post several times and looked at your file and I have
NO idea what you want.
On Friday, September 28, 2012 5:48:22 AM UTC-5, shrini wrote:
>
> Dear All
> Can Any one help me to write a macro for following things.
>
> In sheet 1 I have more than 200 items.I want to make a sam
First. A worksheet event macro must be in the SHEET module (or ThisWorkbook
for all shts). Try this simpler approach using all vba .
'===
option explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim mf As Range
If Target.Column <> 1 Then Exit Sub
'If Target.Address <> Range("c1"
Always show a before/after and the logic
On Thursday, October 4, 2012 1:33:22 AM UTC-5, Vishwanath wrote:
>
> Need help
>
>
> Dear All,
> I need your help in automatic some calculations in spreadsheet.
>
> I have data in excel as below;
> It consists of 2 parts. first part is Expense stateme
You would want to use some autofilter or advanced filter with a series of
input boxes or a user form.
On Saturday, October 27, 2012 3:14:51 AM UTC-5, shrini wrote:
>
> Dear all
>
>
> I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH Example
> .-: user want to find details
Your solution doesn't really pertain to the question but here is yours
cleaned up
Sub RemoveDataSAS() 'No selections.Fire from Sheet2
Dim mv As String
Dim mf As Range
Dim ma As String
If ActiveSheet.Name <> "Sheet2" Then Exit Sub
mv = Application.InputBox(prompt:="Pick a cell.", Type:=8)
With Sh
Why not make your life easier and use ONE sheet for all wtih an extra
column for the name and then use filter to see the individuals as
desired
On Monday, October 29, 2012 6:22:14 AM UTC-5, Pooja S wrote:
>
>
> Hi Team,
>
> Attached is the sheet where in i need some formula to get the below
Should do it in .xlsM workbook.
Sub getallSAS()
Dim i As Long
Dim cr As Double
Application.ScreenUpdating = False
ActiveSheet.UsedRange.Offset(1).Clear
On Error Resume Next
For i = 2 To Sheets.Count
With Sheets(i)
cr = Application.Match("contact", .Columns(1), 0)
.UsedRange.Offset(cr).Copy Cells(Ro
A macro is possible but it probably should be based on an advanced filter.
You need to give much more info on what you want.
On Saturday, October 27, 2012 3:14:51 AM UTC-5, shrini wrote:
>
> Dear all
>
>
> I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH Example
> .-: us
OK
Option Explicit
Sub getallSAS()
Dim i As Long
Dim dlr As Long
Dim cr As Double
Dim slr As Long
Sheets("all up").Select
Application.ScreenUpdating = False
ActiveSheet.UsedRange.Offset(1).Clear
Columns.ColumnWidth = 2
Rows.RowHeight = 4
On Error Resume Next
For i = 2 To Sheets.Count
With Sheets(i
agree!!!
On Monday, October 29, 2012 11:36:55 PM UTC-5, David Grugeon wrote:
>
> I am not going to spend my time downloading your file untill I know what
> it is you want. Please do us the courtesy of copying the steps from the
> file and putting them in your post.
>
> Also put a more relevant
20 matches
Mail list logo