You might try something like this.........

=IF(ISNA(VLOOKUP(A6,Schedule!$A$13:$E$1463,3,FALSE )),"Invalid
Number"&", Four-digit lookup =
"&YourFourDigitLookpuFormula,VLOOKUP(A6,Schedule!$ A$13:$E$1463,3,FALSE))

Vaya con Dios,
Chuck, CABGx3


"Sat3902" wrote:


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


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