Vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am trying to get a vlookup to find data depending on a date.

I am using two worksheets. worksheet A ('Budget to Actual Summary') and worksheet B ('0110-000)
Worksheet A is where I want the data.
I am searching worksheet B based on a date in cell I4 in worksheet A
The date in worksheet B is in row
If the dates match the data I want is in worksheet b, row 33

Here is what I have, to bad it doesn't work!
=VLOOKUP('Budget to Actual Summary'!I4,'0110-000'!33:33,1,FALSE

TI

Todd
 
Vlookup will lookup the value in a table and return a value in the same row
to the right depending
on the index number. Since you put 1 as index number it means it will
lookup the same value as you put in I4 if it can be found.
Maybe you should post what you are trying to do instead

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
=HLOOKUP(I4,'0110-000'!B8:N73,66,0)

or

=INDEX('0110-000'!B73:N73,MATCH(I4,'0110-000'!B8:N8,0))

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Todd said:
Ok. I am looking up data based on a date on a worksheet. Thats cell I$4.
Click to expand...
The data is on a several other worksheets. The date header is Row 8 and
then the data would be in the same column in row 73. I want to find the
relevant data based on the date of the results worksheet.
~~~~
Worksheet B Worksheet C Worksheet C
January February March January February March January February March
01 02 03 01 02
Click to expand...
03 01 02 03
 
Back
Top