Hey guys,
I have full part numbers that I need matched with part number families. 123-456-789 needs to match 123-456-xxx for example. Is there a way to do that? =VLOOKUP(A3,C3:D6,2) obviously doesn't work Thanks!
A B C E
Part number Yes or No Part family
123-456-789 #N/A 123-456-xxx yes
123-456-456 234-567-xxx yes
123-456-888 345-678-xxx no
234-567-898
234-567-888
234-567-882
345-678-111
345-678-555
345-678-888
Bookmarks