Quote:
Originally Posted by jeffreybrown
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),"")
|
Thank you for the advice. I won't be able to try the formula until tomorrow as I'm away from my computer and at work right now. I will let you know the results when I am able to apply them.
Thanks again
Brian