Excel Formula Help Needed

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

Formulas and Functions

SergeiBaklan
Jan 11, 2022
biotek

As variant

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

5 Replies

SergeiBaklan
Diamond Contributor
Jan 11, 2022
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 ?
- biotek
  Copper Contributor
  Jan 11, 2022
  I would like to check if code F2 exists in A:A then return the entire URL to G2 if it finds it.
  - SergeiBaklan
    Diamond Contributor
    Jan 11, 2022
    biotek
    
    As variant
    
    =INDEX( A:A, XMATCH( 1, --ISNUMBER( SEARCH(F2, A:A) ) ) )

Forum Discussion

Excel Formula Help Needed

5 Replies

Resources