Forum Discussion

biotek's avatar
biotek
Copper Contributor
Jan 11, 2022
Solved

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 ea...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 11, 2022

    biotek 

    As variant

    =INDEX( A:A,  XMATCH( 1, --ISNUMBER( SEARCH(F2,  A:A) ) ) )
biotek's avatar
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's avatar
SergeiBaklan
Diamond Contributor
Jan 11, 2022

biotek 

As variant

=INDEX( A:A,  XMATCH( 1, --ISNUMBER( SEARCH(F2,  A:A) ) ) )
  • biotek's avatar
    biotek
    Copper Contributor
    Jan 11, 2022
    Thank you so much!

Resources