Forum Discussion

Hagop Ipdjian's avatar
Hagop Ipdjian
Copper Contributor
Apr 12, 2018

HOW TO: If cell contains specific text that is part of a different list then return specific text

I'm trying to setup a stock in and out spreadsheet with a master sheet that will have all the values automatically calculated. I need help on the formula that will look for the 'sku' in the other she...
Formulas & Functions
Requests
Hagop Ipdjian's avatar
Hagop Ipdjian
Copper Contributor
Apr 13, 2018

Hi There,

 

Firstly thank you for taking the time to read this and reply.

 

I have attached an example file.

 

I need help with Columns B and D which I've highlighted in the spreadsheet attached.

 

I want those to be automatically filled in when i input any information in Column C.

 

The data for this automation is found in Sheet called 'In'.

 

I would like sheet 1 to act as my 'statement' if you like of what i have currently in stock.

 

Once again thank you for your time.

 

  

 

 

Logaraj Sekar's avatar
Logaraj Sekar
Steel Contributor
Apr 14, 2018

Hi Hagop Ipdjian,

 

I've modified your excel file. Just check this what you want.

 

Or else. Ask more.

  • Hagop Ipdjian's avatar
    Hagop Ipdjian
    Copper Contributor
    Apr 23, 2018

    Hi Logaraj,

     

    Thank you for your assistance you have been really helpful.

     

    I'm looking for a different solution now and was wondering if you can help.

     

    I want to automate sheet 1 even further and would like column C to be completed automatically when a New value has been inputted in "In" Sheet but also make provisions to avoid doubles.

     

    Meaning if it already exists in sheet1 please do not re-input.

     

    Looking forward to your reply

     

     Thank You

     

    Best Regards,

    • Logaraj Sekar's avatar
      Logaraj Sekar
      Steel Contributor
      Apr 23, 2018

      Hi 

       

      So,

      1. You want to avoid duplication in "Column C" in "Sheet 1". (You can use Conditional Formatting to avoid duplication or else i should write macro)

      2. If any item added in "Column D", you want to add them in "Sheet 1" automatically. Right?

       

      Clarify the above.

       

       

      • Hagop Ipdjian's avatar
        Hagop Ipdjian
        Copper Contributor
        Apr 24, 2018

        Hi There,

         

        Yeah I would like it to be added in Sheet 1 just once so if I have the same item reoccurring in Column D "In" sheet more than once to appear just once in Column C in "Sheet 1" 

         

        I prefer to have it as a macro to be honest.

         

        Please let me know if the above is better or if you need me to elaborate further.

         

        The objective is to have "Sheet 1" completely automated and to be used as the current stock sheet.

         

        Thank You

Resources