I have items that I'm selling, and I've named these codes with the item I'm selling. I want to give these codes the price they should display. I've already got a formula to show the product of the price and the quantity they want to purchase. I just need to assign these items the price. Help, please.

enter image description here

I've gotten so far as to using an IF operator, but I can only go so far as to just giving it one possible option.

enter image description here

  • Should I use scripting to modify the values, like C1 = 100 and so forth? I'm not sure how G Sheets work with that logic. – Makoro Jul 14 '19 at 12:58
  • delete everything in B column and paste this into B1 cell:

    ={"Price"; ARRAYFORMULA(IFERROR(VLOOKUP(A2:A, H:J, 3, 0)))}

  • delete everything in E column and paste this into E1 cell:

    ={"Total"; ARRAYFORMULA(IF(C2:C<>"", C2:C*D2:D, ))}

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.