|
|
#8
11-12-2016, 06:18 PM
|
|||
|
|||
Since it appears in column B the difference is text versus a number (1, 2, 3, etc.), then this should do it...
Paste into C2 and copy across and down =IFERROR(VLOOKUP($B2,IF(N($B2),'CALL-IN LOG'!$A:$E,PGLLIST),COLUMN(B$1),FALSE),"") 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
|
innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
|
VLOOKUP Formula?
|
ekeithjohnson | Excel | 6 | 08-28-2014 01:16 PM |
|
Vlookup formula
|
teza2k06 | Excel | 2 | 03-18-2014 01:21 PM |
|
I think I need an IF/AND & VLOOKUP formula here
|
Catbert | Excel | 18 | 08-25-2013 07:38 PM |
| Help with VLOOKUP formula | pattyr | Excel | 6 | 08-20-2012 02:20 AM |
Windows Vista 
Office 2007
Threaded Mode