Microsoft Office Forums - View Single Post - best option for vlookup formula

Thread: best option for vlookup formula

View Single Post

Old

11-12-2016, 06:18 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

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),"")

Reply With Quote