Lookup for Part of the number

  • Thread starter Thread starter Kiran
  • Start date Start date
K

Kiran

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
 
=MATCH(A2&"*";Sheet2!A:A;0)

Format both column like text!

--
Regards!
Stefi



„Kiran†ezt írta:
 
Thanks for your help. I also need to know If there is a extra digit in Sheet1
and one digit less in Sheet 2 can we find the match.

Kiran
 
Maybe you meant this:
=MATCH(LEFT(A2,LEN(A2)-1),Sheet2!A:A,0)

--
Regards!
Stefi



„Kiran†ezt írta:
 
Back
Top