SOLVED

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

@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 ?

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)
Solution

@biotek 

As variant

=INDEX( A:A,  XMATCH( 1, --ISNUMBER( SEARCH(F2,  A:A) ) ) )
Thank you so much!

@biotek , you are welcome