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