Forum Discussion

gamblebee's avatar
gamblebee
Copper Contributor
Feb 19, 2019

Need Help with this formula

I have 3 suppliers, Supplier A, B, C, but wants to add validation of their products before I add the cost to the total amount.   Thanks in advance.   It is my first time to post so hoping to get ...
excel
Formulas and Functions
  • gamblebee's avatar
    gamblebee
    Copper Contributor
    Feb 19, 2019
    Hi Twifoo,

    Thanks for your response, however I am looking for a formula that will get the cost of the product from a list of supplier if the value of the product was set to YES and will be addends to a total amount. I don't know, IF and SEARCH Function will work.
    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Feb 19, 2019
      Please illustrate a specific scenario of the output you want.
      • gamblebee's avatar
        gamblebee
        Copper Contributor
        Feb 20, 2019

        Thanks for the reply.

         

        I come up with this formula.

         

        =IF(B$26="YES",VLOOKUP(B$2&$A$26,data,4,FALSE),"0")

         

        I used 2 look up value using &, would there be a simplified formula than this one?

Resources