Lookup function for dates

[stevendt]

Hi,

I have a table which includes a range of start and end dates along with a tariff rate applicable to those dates, e.g.,

Col A Col B Col C
Start Date End Date Rate
01/04/2010 31/03/2011 21.5
01/04/2011 31/03/2012 26.5

I want to lookup the relevant rate based on a date in another cell. I think that I should be able to use a lookup function to do this, but can't work out how - can someone help please?

regards
Dave

[TMS]

Assuming the lookup table is in columns A to C, try:

=VLOOKUP(E2,A:C,3)

where the date to be looked up is in cell E2. Adjust ranges as necessary.

Regards

[stevendt]

Great !

Thanks very much - works a treat

regards
Dave