Need Help with this formula

Copper Contributor

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 a response.

5 Replies
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.
Please illustrate a specific scenario of the output you want.

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?

Given that your lookup-value argument is a concatenation of 2 values, please ensure that the leftmost column of your data range is equivalent to such concatenation; otherwise, your formula shall return the #N/A error if the value of Row 26 is "YES".