Index and Match-find the the matching number

[windme]

Hello Everyone, Using Excel 2007

I'm trying to use the Index and Match function to find today's date in A1:A31 and then find the the matching number in colum B.

Example:

A B
8/1/08 45
8/2/08 36
8/3/08 38
8/4/08 66
8/5/08 31
8/6/08 84
8/7/08 21
8/8/08 75
8/9/08 64
8/10/08 75
8/11/08
8/12/08

This is the formula that i am using:

Please Login or Register  to view this content.

but I am receiving an error message #NAME?.
Need help to get the formula to return 75.

Thanks.
Mike

[robert111]

can you use offset and match functions to avoid the use of code?

insert a new row at top and name cell A1 as "start"

=offset(start,match(f1,a2:a10,0),1)

where today's date is in f1

[davesexcel]

This would work in your situation...
=VLOOKUP(TODAY(),A1:B13,2,0)

[windme]

Thank you guys, using the VLOOKUP. Works great.

Mike

[martindwilson]

just fyi
the index/match was constructed wrongly it should have been

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

the extra brackets really just show how match fits into the index function but are useful if you wanted to change the match value say add 1