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