Evening Chuck

I tried your suggestion

=IF(ISNA(VLOOKUP(A9,'Schedule'!$B$2:$C$20882,2,FAL SE)),"Invalid
Number"&","&VLOOKUP(LEFT(A9,4),$A$2:$C$20882,2,FAL SE),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$14 63,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,FAL SE)),"Invalid
Number"&","&VLOOKUP(LEFT(A9,4),$A$2:$C$20882,2,FAL SE),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$14 63,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 day


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