finding differences between two worksheets

sobik

New Member
Joined
Nov 9, 2005
Messages
15
hello, me again.

a have two worksheets that contains similar information. in the first one there is a list of things with prices and in the second there is list of things without prices.

BUT

the lists are not the same. i need to highlight items that are not present in both worksheets. is that possible?

thanks a lot
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

colbymack

Active Member
Joined
Jul 14, 2005
Messages
333
use the vlookup command in both spreadsheets. If you use it from spreadsheet A to spreadsheet B, it will show those values in A that are not in B. Vice versa from B to A.

HTH,
Colbymack
 

sobik

New Member
Joined
Nov 9, 2005
Messages
15
what is vlookup please? i don't have english version of excel, just czech, so if you would be so kind and explain it a little more...

but still thank you very much for help!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,388
Messages
5,571,847
Members
412,420
Latest member
grace_abar
Top