=MATCH(A2&"*";Sheet2!A:A;0)

Format both column like text!

--
Regards!
Stefi



€žKiran€� ezt Ã*rta:

Hi,

I need to lookup for a Loan Number from another sheet. However the problem
is sometimes one digit would be added to the end in the other worksheet. Is
there a way to find match for this digit.For the digits in below list I need
to get the match as true for 12345 and 12346 as there is 123451 and 123462 in
2nd Sheet.

List in 1st Sheet
Loan#
12345
12346
12347


List in 2nd Sheet
Loan#
123451
123462
234728