Hi all.......New to the forums....
This task has me a bit stumped, as I'm not yet fluent in formulas. Basically, I have a large column list with product SKUs. The example shows that pairs of SKUs are similar, but one has additional characters for a special version of the product and is more expensive. I'm trying to come up with a formula that finds the higher item (500FBCLIKA-BOD), get the price, and then subtract the price of the similar, lower value SKU (500FBCLIKA).
A B C 1 SKU Price Difference 2 500FBCLIKA 383 3 500FBCLIKA-BOD 495
All I could come up with is:
=VLOOKUP(A2&"-BOD",$A$2:$A$1898,2,FALSE)-A2
Which of course does not work.
Any of you Spreadsheet Wizards know what I should be correcting or using?
Thanks!
Bookmarks