Peter Muller
Board Regular
- Joined
- Oct 15, 2018
- Messages
- 133
- Office Version
- 365
- 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 1-Gr C |
MAN2 | Alb 1-Gr D | |
MAN3 | There are 8 nested "if" statements - 8 different sheets | Alb 1-Gr E |
MAN4 | How to use the wild card with "Alb 1" , "Cap 1" , etc. | Cap 1-Gr C |
MAN5 | Cap 1-Gr D | |
MAN6 | Cap 1-Gr E |