Forum Discussion

Susan1085's avatar
Susan1085
Copper Contributor
Mar 13, 2024

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...
excel
Formulas and Functions
Rodrigo_'s avatar
Rodrigo_
Iron Contributor
Mar 16, 2024

Susan1085 

use this formula next to you data

=IFERROR(IF(VLOOKUP(C2,A:B,2,FALSE)=D2,"Match","Mismatch"),"Product Code Not Found!")

Match = represents the prices are the same,
Mismatch = there is discrepancies on the prices 

 

Resources