best option for vlookup formula

jeffreybrown · #1 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),"")

Bdcrawford · #2 11-12-2016, 06:48 PM

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

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