Nested Vlookups

[Griffen]

Hello All;

I'm trying to create a vlookup using a second criteria, and thought about
writing a nested Vlookup in the same format as nested "IFs". Nothing seems
to work the same way. Has anyone written a nested Vlookup or is it possible?

In short, I'm trying to pull data from a table based on the month of the
year. So the Vlookup would vary based upon the monhth of the year, and thus
the nested lookup function.

Thanks,

 

[John]

HI
Are you looking for something like this
=IF(A1=DATE(YEAR(A1),MONTH(A1),1),VLOOKUP(A2,B3:E18,2,FALSE),"").
If the date match it will lookup the information only.
HTH
John

 

[veryeavy]

Not "NZ Chch Griff" by any chance?

Just wondered ...

Matt Geare