1 VLOOKUP question

[cpliu]

12/6/2007 Item 1 0.15
5/30/2008 Item 2 0.33
11/6/2007 Item 3 1.00
11/7/2007 Item 4 1.00
11/7/2007 Item 5 1.00

Item 3

Assuming the data above starts from A1:
If I put =VLOOKUP(B7,$B$1:$C$5,2,FALSE) in C7, I can get 1.00 fine.
But, how about column A (date)? I tried: =VLOOKUP(B7,$A$1:$B
$5,1,FALSE) in cell A7, but I got N/A.

I'd like to compare the data above and put 11/6/2007.

Thanks for the help,

 

[Bernard Liengme]

=INDEX(A1:A5,MATCH(B7,B1:B5,0))
Column A has dates but this may return the serial number of that date ( a 5
digit number like 39392) - all that is needed is to format the cell as Date
You may wish to add $ (absolute references) to this formula
best wishes

 

[Billy Liddel]

I'm not sure about your ranges but this is one way:

=INDEX(A2:A6,MATCH("Item 1",B2:B6,0))

A2 to A6 is the date range. Substitute "Item 1" by your reference cell.

HTH
Peter

 

[cpliu]

=INDEX(A1:A5,MATCH(B7,B1:B5,0))

That works!! THANKS for the help.