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

Similar Threads

Improving Nested Formula Calculation Efficiency 2
nested if vba problem 3
Vlookup in multiple arrays 1
Embedded If Limitation 10
Is a Nested Formula what I need? 1
if function (if more that 7 nesting) 2
Vlookup Loop 1
Excel Trying to do a vlookup with a nested right function on the array 3

Top