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 vlookup wildcard no longer find the match like they do in VLOOKUP. Can you help?
Solved by S. J. in 12 mins