finding differences between two worksheets

[sobik]

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

 

[colbymack]

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]

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!

 

[colbymack]

Try looking at these links for some help:
http://www.mrexcel.com/board2/viewtopic.php?t=184857

http://www.mrexcel.com/board2/viewtopic.php?t=165530

HTH,
colbymack