Hello,
I am pretty new at using Excel, so thank you in advance for your help. I have two columns of data shown below.
Parts list Part number
xyzP987rty *P987*
rzyP632rty *P632*
xykP987rty *P345*
addP345rsa
I needed to find which part numbers exist on the parts list. Knowing that the parts list have the part numbers in the middle of a lot of other useless numbers I placed wildcards at the beginning and end of each part number. Then I used this formula:
vlookup(B2,A2:A5,1,False)
It returned with xyzP987rty, but I also need it to also return with xykP987rty. Is there any way for me to use one criteria, such as P987 and return with multiple results such as xyzP987rty and xykP987rty. Thanks again
Bookmarks