Forum Discussion
Solved
Apply one markup if A matches B, else apply second markup
Hi there, I am new to this forum, and still quite new to excel too, so please be gentle with me :-) I am looking to apply a formula that will check to see if the Product Code starts with a specific...
Hi Karen,
Welcome to Microsoft Excel Community!
I think that the definition of markup is the amount you want to add it to the unit price.
Based on this definition, please put this formula in cell D2 and drag it down:
=IF(LEFT(A2,1)="b",(C2*VLOOKUP(B2,$F$2:$H$4,2,0))+C2,(C2*VLOOKUP(B2,$F$2:$H$4,3,0))+C2)
I hope this helps you
Haytham
Hi Karen,
Welcome to Microsoft Excel Community!
I think that the definition of markup is the amount you want to add it to the unit price.
Based on this definition, please put this formula in cell D2 and drag it down:
=IF(LEFT(A2,1)="b",(C2*VLOOKUP(B2,$F$2:$H$4,2,0))+C2,(C2*VLOOKUP(B2,$F$2:$H$4,3,0))+C2)
I hope this helps you
Haytham
Ohhh, you are a star. That works great! Thank you sooooooo much :-)