Forum Discussion

KellyJ15's avatar
KellyJ15
Copper Contributor
Oct 29, 2019

Excel Data Fields

Hello

 

I have an Excel spread sheet that I need to fill in monthly. I need to get values in column G according to text that is placed in column C or D. The values for the text is on sheet2 in multiple columns. 

I have attached an example if anyone could possibly help out.

 

 

excel
Formulas and Functions

3 Replies

    • KellyJ15's avatar
      KellyJ15
      Copper Contributor
      Oct 29, 2019

      Wyn Hopkins  It doesn't really help. I need a formula that will automatically give the cost price of an item into column G. eg if I input gloves into column D2 the amount of R4.00 will automatically go into column G2 which will then give me the answer of SUM= F2*G2. This needs to happen throughout the spreadsheet without me having to put in a formula each time.

      • Wyn Hopkins's avatar
        Wyn Hopkins
        MVP
        Oct 29, 2019
        Hi,
        Could you explain this a bit more when you say "it needs to happen throughout the spreadsheet without having to put the formula in each time".

        I don't understand what my formula is doing wrong

Resources