| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup for Part of the number
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup for Part of the number
=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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup for Part of the number
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 "Stefi" wrote: =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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup for Part of the number
Maybe you meant this:
=MATCH(LEFT(A2,LEN(A2)-1),Sheet2!A:A,0) -- 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 "Stefi" wrote: =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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 part lookup question | Excel Worksheet Functions | |||
| Look up part of a number within a serial number and cpy back assoc | Excel Worksheet Functions | |||
| Multi Part Lookup | Excel Discussion (Misc queries) | |||
| lookup part number in a vertical list and return the most recent . | Excel Discussion (Misc queries) | |||
| Part Number Lookup | Excel Worksheet Functions | |||
Linear Mode
