Forum Discussion
Excel..nested vlookup possibly..looking for help
Hi All Column A & B are exported form pricing software - Column A is product codes. Column B is current product prices. Column C & D are exported from daily salesbooks every morning. C is Product C...
You could use the following formula
=IFERROR(D2-(VLOOKUP(C2,A:B,2,0)),"Product not found")
This formula does a vlookup to find the price from your pricing software (col A & B) and then subtracts that number from the salesbook value giving you the difference as well. Anything that has a 0 as the output is a perfect match, while a positive number means that the salesbook value is higher and negative meaning the pricing software values are higher.
Additionally I put in conditional formatting to show colored arrow to display wherever you see a number whether +ve, -ve or 0.
Attached the file for your reference.