Tag Archives: cell

Compare Multiple Fields with Excel vlookup (Easy)

When you need to determine whether several fields in 2 Excel documents (or tabs) match, all you need to do is combine the fields in each document into one value and then compare the 2 values using vlookup.

You could do this many ways, but if you’re new to Excel formulas, I think this way is easier to configure and understand. I’m assuming you’re familar with the basics of Excel and vlookup already.

If you are not familiar with vlookup, you might want to review this first, as my post does not teach you vlookup, just another way to use it.

Continue reading

Advertisements

12 Comments

Filed under Audit, Data Analytics, Excel, How to...

Phony Charges (this time, it’s personal)

I upgraded my cell phone plan to save money, but discovered phony charges instead. I got all new phones and went from 700 minutes to 900 minutes, and my bill was supposed to drop about $30 a month. Then I opened my next bill, which was the first bill on the new plan. Merry Christmas, it’s $35 more than expected!

Continue reading

3 Comments

Filed under Audit