Excel Formula Help Needed

[biotek]

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!

[#2]

@biotek 

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 ?

[#3]

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

[#4 · Accepted solution]

@biotek 

As variant

=INDEX( A:A,  XMATCH( 1, --ISNUMBER( SEARCH(F2,  A:A) ) ) )

[#5]

Thank you so much!

[#6]

@biotek , you are welcome