Forum Discussion
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....
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
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