spanspace
Board Regular
- Joined
- Jan 3, 2007
- Messages
- 159
Ok so when I point the vlookup in F9 to B9 I get a big fat #n/a. If the information in b9 was just the number and the the left formula it would work. I need help resolving this. I am sure its something easy..but my mind is moosh already from other projects.
Excel 2007
Excel Workbook | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
8 | UNIQUE ID | ID | Agent Name | Role | Site IBADE | Site | Agent ID | ||
9 | 8886 | Add Agent to Master | #N/A | #N/A | #N/A | 8886 | |||
WTD Conversion |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A9 | =IF(C9="Add Agent to Master","",CONCATENATE(B9," ",C9)) | |
B9 | =LEFT(G9,4) | |
C9 | =IF(ISBLANK(G9),"",IF(ISNA(VLOOKUP(E9,Agents!$I$2:$L$600,4,FALSE)),"Add Agent to Master",VLOOKUP(E9,Agents!$I$2:$L$600,4,FALSE))) | |
D9 | =IF(A9=" ","",IF(ISBLANK(A9),"",VLOOKUP(A9,Agents!$C$2:$DE$640,MATCH("Role",Agents!$C$2:$DE$2,0),FALSE))) | |
E9 | =IF(ISBLANK(G9),"",CONCATENATE(F9," ",LEFT(G9,4))) | |
F9 | =VLOOKUP(B9,Agents!$A$7:$F$640,MATCH("Site",Agents!$A$7:$F$7,0),FALSE) |