Forum Discussion
Assistance with complex VLOOKUP formula
Hi everyone, I need some help with a formula I'm using to fill in the Manager’s email. Here is the formula: =IF(F2="", "", VLOOKUP(IF(VLOOKUP(F2, $A$2:$I$1400, 4, FALSE) = 0, VLOOKUP(F2, $A$2:$I$1...
Sample data in the attachment. For some reason I get a 'HTML' error when putting the table in the body of the post
Hi - does this do the trick? I've shorten the lookup array to what you provided, you will need to adjust accordingly. This does pick up email p26#gmail.com for 7586.
=IF($F2="","",IF(VLOOKUP($F2,$A$2:$I$11,4,FALSE)<>0,VLOOKUP($F2,$A$2:$I$11,9,FALSE),IF(VLOOKUP(VLOOKUP($F2,$A$2:$I$11,6,0),$A$2:$I$11,4,FALSE)<>0,VLOOKUP(VLOOKUP($F2,$A$2:$I$11,6,0),$A$2:$I$11,9,FALSE),VLOOKUP(VLOOKUP(VLOOKUP($F2,$A$2:$I$11,6,0),$A$2:$I$11,6,FALSE),$A$2:$I$11,9,0))))