Nested Vlookups


G

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,
 
Ad

Advertisements

J

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top