CODEWITHSUNDEEP
excelsearchmatching
user3352695
user3352695

Reputation: 1

Large Multi search, to match numbers in one column, with Hyperlinks containing those numbers in another column

I have one column with about 4000 Part Numbers. Another column with about 8000 hyperlink URLs containing the part numbers. I want to match the part numbers with thier URLs. Manually searching each one will take forever.

Upvotes: 0

Views: 45

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35853

Let your Part number be in A1 and your URLs in column F, than use in B1 

=INDEX(F:F,MATCH(1,1/ISNUMBER(FIND(A1,F:F)),0))

and press CTRL+SHIFT+ENTER to evaluate it. Drag this formula down.

Note, this formula finds first URL, which contains path number.

Upvotes: 1

Related Questions