Excel Formula Help Needed

New Contributor

Hi All. I'm having trouble making a formula and would greatly appreciate any help I can get. Im trying to find a URL from row A that has the code found in Row F then output the result to Row G for each cell in row F. See below for picture of what I am working with.


Thank you so much in advance!


Excel Screenshot.png

5 Replies


You would like to check if Code in F2 exists within URL in A2, etc, or you would like return in G2 URL form column A which has the same code as in F2 ?

I would like to check if code F2 exists in A:A then return the entire URL to G2 if it finds it.

best response confirmed by biotek (New Contributor)


As variant

Thank you so much!

@biotek , you are welcome