A1-A100 contains a list of links (created from a macro). They have 2 sets of text.
Ex: 100E id.jpg or 2442E id.jpg
Column B contains the list of all the pole numbers, from 100E(B2) to 2442E (B100)
How do I get the IF statement to say: If the word "id" and the pole number from B2 are found in the same cell somewhere in A1-A100, then create a hyperlink at C2 (I believe I know how to do the hyperlink part). That way I can just drag the formula from C2 down the list so that I don't have to type for C3 the pole number. Instead it will just reference B3.
Bookmarks