IF & Vlookup Assistance

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.
 
J

JMB

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top