Peter Muller
Board Regular
 Joined
 Oct 15, 2018
 Messages
 89
 Office Version

 2016
 Platform

 Windows
Good afternoon Experts,
I am battling to use the wild card in this “if” and “vlookup” formula.
I have in excess of a 2000 entries and 8 sheets.
Please help.
I am battling to use the wild card in this “if” and “vlookup” formula.
I have in excess of a 2000 entries and 8 sheets.
Please help.
Ref  Name  Designation 
MAN1  =IF(C2="Alb 1",VLOOKUP(A2,Albany!A:B,2,FALSE), IF(C2="Cap 1", VLOOKUP(A2,Cape!A:B,2,FALSE)))  Alb 1Gr C 
MAN2  Alb 1Gr D  
MAN3  There are 8 nested "if" statements  8 different sheets  Alb 1Gr E 
MAN4  How to use the wild card with "Alb 1" , "Cap 1" , etc.  Cap 1Gr C 
MAN5  Cap 1Gr D  
MAN6  Cap 1Gr E 