Excel - Help on VLOOKUP Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have two lists. One is a list of part numbers. The other is a list of long text descriptions. I can use VLOOKUP with "*"&cell address"*" to find the first match. But how can I find the second and third matches? I have tried using INDEX and SHORT but the wild cards no longer find the match like they do in VLOOKUP. Can you help?
Solved by S. J. in 36 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 19/06/2018 - 06:45
hello, how are you?
User 19/06/2018 - 06:46
I'm good. You?
User 19/06/2018 - 06:46
Thanks for helping me.
Excelchat Expert 19/06/2018 - 06:47
Am also good, examining your problem
User 19/06/2018 - 06:47
I can't send you my sheet. It has proprietor company data on it.
Excelchat Expert 19/06/2018 - 06:50
Can you type one example on the spreadsheet besides the chat box for clarity purposes. I will see it
User 19/06/2018 - 06:51
one moment please
Excelchat Expert 19/06/2018 - 06:53
User 19/06/2018 - 06:53
I'm back - Phone :(
User 19/06/2018 - 06:54
I normally can find text like that.
User 19/06/2018 - 06:54
I can't find the second incident of it.
User 19/06/2018 - 06:55
Do you see my problem?
User 19/06/2018 - 06:59
I am looking for a formula to put in D2 and E2 that will give me that result.
User 19/06/2018 - 07:01
I can use the wildcards with INDEX/MATCH but not with SHORT/INDEX which can find the next match.
Excelchat Expert 19/06/2018 - 07:02
Let me have a look at it and revert shortly
User 19/06/2018 - 07:02
Excelchat Expert 19/06/2018 - 07:07
Wait a minute, in what order do you want the numbers to output, because i don't see the relationship between 12 and part 234 brake
Excelchat Expert 19/06/2018 - 07:07
It seems as if its a matter of transposing the numbers
User 19/06/2018 - 07:08
In reality the vendor part number and the stuff in B is our internal mumbers at different plants. I need to find them all.
User 19/06/2018 - 07:09
A has the vendor part number in the long text. We have these parts in different plants with our own numbers but we have duplicates. I need to find the dupicates. But the vendor number is buried inside the long text.
User 19/06/2018 - 07:11
If I had known that we could share a sheet like this I would have prepared a better example ahead of time.
Excelchat Expert 19/06/2018 - 07:11
Check on the spreadsheet please
User 19/06/2018 - 07:12
Where? What cell?
Excelchat Expert 19/06/2018 - 07:13
What you try generating the numbers inside the texts?
Excelchat Expert 19/06/2018 - 07:15
User 19/06/2018 - 07:16
My example is really bad. I think I need to make a better sheet and get in touch iwth you again. I'm sorry I wasn't better prepared to talk wth you. I appreciate your trying to help.
Excelchat Expert 19/06/2018 - 07:18
Create a clearer example so that we can just tackle it with more clarity. I will take the query once you come back. Is that in order?
User 19/06/2018 - 07:18
Sounds good. It won't be today. Day is almost over. Is that okay?
Excelchat Expert 19/06/2018 - 07:20
No pressure. But when you come just repeat the same instructions so that i can know your issue and pick it up. To end the session you need to click on the orange button above the sheet
User 19/06/2018 - 07:20
Will do. Thanks again. :)
Excelchat Expert 19/06/2018 - 07:20
Am happy to serve you, have a great time

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc