Forum Discussion

Alessiothegreat's avatar
Alessiothegreat
Copper Contributor
Feb 25, 2021

Formula finding data in one cell but not another

Hi everyone,   I am having difficulty trying something new in my formula.   How the spreadsheet works up to the point of this formula : A list of plants is entered into a data tab, there are the...
Formulas and Functions
Alessiothegreat's avatar
Alessiothegreat
Copper Contributor
Feb 25, 2021

Riny_van_Eekelen 

This is to create an availability list of stock we currently have which regularly gets emailed to clients for them to choose what they want and see what we have in stock. It is much easier for these to be categorised into different tabs.

 

Thanks

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 25, 2021

Alessiothegreat Why then not just filter and copy paste into a new sheets and then delete the master table befor emailing?

Otherwise, if you are a MS365 subscriber, the FILTER function could do this also.

  • Alessiothegreat's avatar
    Alessiothegreat
    Copper Contributor
    Feb 25, 2021

    Riny_van_Eekelen 

    As i have created this for my boss and he is not very good on computers so have created this spreadsheet so all he has to do is copy and paste. Also it is alot quicker for the formulas to automatically sort all the data exactly how i want it. 

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Feb 25, 2021

      Alessiothegreat Okay! Difficult to diagnose a formula that doesn't seem to work without having the file/data to test on.

      • Alessiothegreat's avatar
        Alessiothegreat
        Copper Contributor
        Feb 25, 2021

        Riny_van_Eekelen 

        Thankyou for your help i really appreciate it.

         

        Please see attached the file.

         

        I am trying to for instance on the "Shrub Std" tab to have columns AB-AF etc work the same as the "conifer" tab does but using the match of Data!Q or Data!P instead of cloumn D.