Complex Look Up
 

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??

Complex Look Up
 

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


"5F80YZ" wrote in message
...
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??

Complex Look Up
 

Mate, you are a legend!!

Thanks !!

"T. Valko" wrote:

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


"5F80YZ" wrote in message
...
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??




.

Complex Look Up
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"5F80YZ" wrote in message
...
Mate, you are a legend!!

Thanks !!

"T. Valko" wrote:

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


"5F80YZ" wrote in message
...
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??




.

Complex Look Up
 

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.


"T. Valko" wrote:

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


"5F80YZ" wrote in message
...
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??




.