Forum Discussion

Vanessa McKay's avatar
Vanessa McKay
Copper Contributor
Jun 07, 2017

Formula help please

Hi. I need some help writing a formula. I have only basic formula skills and I need to write a formula that  if a particular number is entered in a cell then the next cell will show a value for that....
Formulas & Functions
Need Help
Logaraj Sekar's avatar
Logaraj Sekar
Iron Contributor
Jun 07, 2017

Hi Vanessa McKay,

 

Good Morning.

 

It is very easy. In one sheet, Please list out all classes in "Column A" and in next column specify the entry fee. This is base data for bringing entry fee to where you want.

 

Now, go to the cell where you want the result and put formula.

 

Eg.

If you have base data in "Sheet1" and you specifying class name in "Cell A2" in "Sheet2", put the formula in B2.

 

=VLOOKUP(A2,Sheet1!A:B,2,0)
  • Vanessa McKay's avatar
    Vanessa McKay
    Copper Contributor
    Jun 07, 2017

    Thank you! I have done this and it worked well. The next issue I have come across is that my "total" formula adding the cost of all the entries is not working now. I have allowed 40 lines for the entry of class No's and if all 40 are completed then my sum works but where they aren't it my entry fee column shows #N/A which I'm assuming is why my total sum formula isn't working. If you could advise how to fix that, I'd really appreciate it. Thanks

    • Anders Florinus's avatar
      Anders Florinus
      Copper Contributor
      Jun 08, 2017

      Hi @Vanessa McKay!

      Try this:

      =IFERROR(VLOOKUP(A2,Sheet1!A:B,2,0);"0")

      This will replace your #N/A with 0 and the adding will work.

      /Anders 

Resources