Lookup for Part of the number

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
 
S

Stefi

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

Format both column like text!

--
Regards!
Stefi



„Kiran†ezt írta:
 
K

Kiran

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
 
S

Stefi

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

--
Regards!
Stefi



„Kiran†ezt írta:
 

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

Similar Threads

Lookup 1
do i use countif? 2
Compare Differences of 2 Tables 4
listing the number 1 at the end of 4
Comparing two sets of columns 2
Formatting cells with numbers 3
lookup values on two worksheets 1
How do I create a lookup using layered parameters 2

Top