Feb 18 2019 07:13 PM
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.
Feb 18 2019 08:50 PM
Feb 18 2019 10:05 PM
Feb 18 2019 11:19 PM
Feb 19 2019 06:14 PM
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?
Feb 20 2019 12:27 AM