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) ) ) )
SergeiBaklan's avatar
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'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