Afternoon,

I know some one out there might be able to assist me with my dilemna.

In Sheet1 I have a list of 8 digts id numbers in column A and in sheet2 is where I am doing the lookup from.

The formula below is working great. I picked up from this website.


=IF(ISNA(VLOOKUP(A6,Schedule!$A$13:$E$1463,3,FALSE)),"Invalid Number",VLOOKUP(A6,Schedule!$A$13:$E$1463,3,FALSE))

What I need to know if possible is, can another (vlookup or if ) be added to the ending formula to do search on just the first 4 number of the id, if I got the response Invalid Number.

I currently have another column doing the lookup on just the 4 digits.

Thanks