Complex Look Up

5

5F80YZ

Hi. I desparately need help with this look up function

The look up data is as below

Sheet 1
Column A Column B Column C
26/10/09 25/11/09 1.123
26/11/09 25/12/09 1.654
26/12/09 25/01/09 1.897

Sheet 2
Column A Column B
05/11/09 ________
15/01/09 ________
21/12/09 ________

OK, what I need to do is in Sheet 2, I need to look up for the dates in
column A and get the look up value from Column C is Sheet 1. Can someone
please help me??
 
T

T. Valko

Assuming the dates on sheet1 are sorted in ascending order as is shown in
your sample data...

=LOOKUP(A2,Sheet1!A$2:C$4)
 
5

5F80YZ

Mate, you are a legend!!

Thanks !!

T. Valko said:
Assuming the dates on sheet1 are sorted in ascending order as is shown in
your sample data...

=LOOKUP(A2,Sheet1!A$2:C$4)

--
Biff
Microsoft Excel MVP





.
 
M

Minty Fresh

Column B becomes irrelevant with =Lookup() because the function only checks
the values in the first column of your lookup array, and matches the next
lowest value when it does not find the exact value you are looking for.
If the date you are trying to find is beyond the last period defined in your
lookup array, =lookup() is going to return the exchange rate from the last
row.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top