Evening Chuck

I tried your suggestion

=IF(ISNA(VLOOKUP(A9,'Schedule'!$B$2:$C$20882,2,FALSE)),"Invalid
Number"&","&VLOOKUP(LEFT(A9,4),$A$2:$C$20882,2,FALSE),VLOOKUP(A9,'Schedule'!$B$2:$C$20882,2,FALSE))

I got a messg #N/A. I tried it in a smaller size worksheet.

example
Sheet 1 is where I am doing the Vlookup from. Sheet 1 has 3 column with
data col A contain both 8 digits and 4 digit user Id Col B contains the
location and Col C contains the terminal ID.

Sheet 2 is where I have the formulas doing the IF & Vlookup from.
Col A is where I import the data into. Col B & C contains the formula
Col B
=IF(ISNA(VLOOKUP(A7,Schedule!$A$13:$E$1463,3,FALSE)),"Invalid
Number"&"",VLOOKUP(LEFT(A7,4),Schedule!$A$13:$E$1463,3,FALSE))

Col C ( If i do not get a match on the 8 digit then I use the 4 digit
result)

=IF(ISNA(VLOOKUP(LEFT(A8,4),Schedule!$A$12:$E$1439,3,FALSE)),"Invalid
Number",VLOOKUP(LEFT(A8,4),Schedule!$A$12:$E$1439,3,FALSE))

Is there a way to combine both formulas ( Col b then col C ) into one
formula / argument.


--
Sat3902
------------------------------------------------------------------------
Sat3902's Profile: http://www.excelforum.com/member.php...o&userid=36777
View this thread: http://www.excelforum.com/showthread...hreadid=569233

Your response s/b posted in the original thread, otherwise it is a craps
shoot whether or not the intended recipient will see your reply.

"Sat3902" wrote:

>
> Evening Chuck
>
> I tried your suggestion
>
> =IF(ISNA(VLOOKUP(A9,'Schedule'!$B$2:$C$20882,2,FALSE)),"Invalid
> Number"&","&VLOOKUP(LEFT(A9,4),$A$2:$C$20882,2,FALSE),VLOOKUP(A9,'Schedule'!$B$2:$C$20882,2,FALSE))
>
> I got a messg #N/A. I tried it in a smaller size worksheet.
>
> example
> Sheet 1 is where I am doing the Vlookup from. Sheet 1 has 3 column with
> data col A contain both 8 digits and 4 digit user Id Col B contains the
> location and Col C contains the terminal ID.
>
> Sheet 2 is where I have the formulas doing the IF & Vlookup from.
> Col A is where I import the data into. Col B & C contains the formula
> Col B
> =IF(ISNA(VLOOKUP(A7,Schedule!$A$13:$E$1463,3,FALSE)),"Invalid
> Number"&"",VLOOKUP(LEFT(A7,4),Schedule!$A$13:$E$1463,3,FALSE))
>
> Col C ( If i do not get a match on the 8 digit then I use the 4 digit
> result)
>
> =IF(ISNA(VLOOKUP(LEFT(A8,4),Schedule!$A$12:$E$1439,3,FALSE)),"Invalid
> Number",VLOOKUP(LEFT(A8,4),Schedule!$A$12:$E$1439,3,FALSE))
>
> Is there a way to combine both formulas ( Col b then col C ) into one
> formula / argument.
>
>
> --
> Sat3902
> ------------------------------------------------------------------------
> Sat3902's Profile: http://www.excelforum.com/member.php...o&userid=36777
> View this thread: http://www.excelforum.com/showthread...hreadid=569233
>
>

I thought I had done a reply.

I guess this will be a redo.

have a nice da

--
Sat390
-----------------------------------------------------------------------
Sat3902's Profile: http://www.excelforum.com/member.php...fo&userid=3677
View this thread: http://www.excelforum.com/showthread.php?threadid=56923