HI
Are you looking for something like this
=IF(A1=DATE(YEAR(A1),MONTH(A1),1),VLOOKUP(A2,B3:E1 8,2,FALSE),"").
If the date match it will lookup the information only.
HTH
John
"Griffen" wrote in message
...
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,