•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Finding and comparing values across two tables
I have two tables: one has the name for my products and it's correct value. The other contains the name of the products and the value at which said product was sent to a client.
I want to compare both tables and highlight any instances where the product was sent with the wrong value in the second one.
Edit:
As an example, in Table 1, the product A173 costs R$252,00.
In Table 2, I have multiple instances of this product, but on line 354 the second to last column doesn't match with Table 1's value. I want to highlight this line so I can quickly find it and adjust it.
[link] [comments]
Want to read more?
Check out the full article on the original site