Creating a nested If function with multiple vlookups

**Symeoni1** · 01-10-2012, 01:36 PM

Hi~

I'm trying to setup a vlookup that knows based on the selected filtered data which worksheet to pull from. I think I could create a nested IF formula, but I’m having a hard time with it. Here is what I currently have....

=IF(AA5=Category Data,"(VLOOKUP(AA15,'Category Data'!B:G,6,FALSE)",IF(AA5=MFR Data,"(VLOOKUP(AA15,'Unilever Data'!B:G,6,FALSE)"))

For example: if AA5=Category data then I want it to use the following vlookup... and if AA5=MFR Data then I want it to use the other vlookup... I can't think of anyother way to set it up.

Please help

**dilipandey** · 01-10-2012, 01:41 PM

Hi Symeoni,

Welcome to the forum.

You only need to put the quotes in correct place, see the revised formula

=IF(AA5="Category Data",VLOOKUP(AA15,'Category Data'!B:G,6,FALSE),IF(AA5="MFR Data",VLOOKUP(AA15,'Unilever Data'!B:G,6,FALSE),""))

If you still have any issues, please upload the sample file. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**NBVC** · 01-10-2012, 02:53 PM

Can be simplified a bit to:

=VLOOKUP(AA15,IF(AA5="Category Data",'Category Data'!B:G,'Unilever Data'!B:G),6,FALSE))

Creating a nested If function with multiple vlookups

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Creating a nested If function with multiple vlookups

Re: Creating a nested If function with multiple vlookups

Re: Creating a nested If function with multiple vlookups

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions