Match & highlight codes in worksheets

[esh27]

I wonder if someone can help - I have just started using a dropship company and each day they update the number of items they have in stock for each product they sell onto an excel worksheet. I have also created a worksheet of my own which lists all of the items I am looking to sell on my website (mine contains a couple of hundred items and theirs a couple of thousand).

I am relatively new to Excel and what I am looking to do is put the two worksheets (my products and the full range of their products and stock info) onto one workbook daily and then run an action which highlights matching item codes. This way I will save time as rather than going through the thousands of items which are being updated daily by the dropship company I can quickly glance over the highlighted ones to check stock levels against the products I am selling. I hope this makes sense and someone can point me in the right direction,

Many Thanks

[Richard Buttrey]

Hi,

Try the =MATCH() function. It will result in an error if there is no match, which you could trap by adding an =IF() and ISERROR() function. e.g.

Please Login or Register  to view this content.

[esh27]

Thanks very much Richard - I will give this a try and let you know :-)