S
Sat3902
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.
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.