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