Complex Look Up

  • Thread starter Thread starter 5F80YZ
  • Start date Start date
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??
 
Assuming the dates on sheet1 are sorted in ascending order as is shown in
your sample data...

=LOOKUP(A2,Sheet1!A$2:C$4)
 
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





.
Click to expand...
 
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.
 
Back
Top