VLOOKUP on a date range

Originally Posted by Althas

A Wet and good morning to you all

I am wanting to use a vlookup function on a sheet, but can not work out how to use a range as the lookup

I have attached a small extract of my sheet

Basically what I want to do is look at the date in column C in the table F - H, and return the value in H, but I do not have the first clue how to use a range to lookup. I have searched many threads but can find none to match, can anyone help please?

Thanks in advance

Hi,

keep the dates in sequence and use the True form of VLookup

=VLOOKUP(C1,F$2:H$6,3,TRUE)

note, column G is ignored.

hth
---

Originally Posted by Althas

Great, thanks for that Bryan, had no idea it was that simple

Much appreciated

Have a good day everyone

good to see it works for you, and thanks for the response.
---