How to : Comparing Two Ranges

[lockwood7]

I run an auto parts business. I have a list of parts in my excel data
base. When parts are sold throught the web, I need to download the
list and compare it to the list of parts in the database. Any parts
that no longer show on the web must be deleted from the list in excel.
How do I compare the two lists and view the exceptions? I thought I had
figured it out using the EXACT function, but it is not working
properly.

Thanks-
John

 

[Steve Mackay]

Would help if you explained a little more about the format. However,
if the Web list is in Column A (I'm assuming 500 parts) and the
Database is in column B, then in C1 you could use this formula and copy
down to the the end of the list:

=countif(B1,$A$1:$A$500)

any cell with "0" you could delete.

 

[Karthik]

Hi

You should use Vlookup function. To know more about how to use this
function please read the below page

http://office.microsoft.com/en-us/assistance/HA010563201033.aspx

Thanks
Karthik Bhat
Bangalore

 

[lockwood7]

Thank you for your quick replies. Your help has proven very valuable.

John