Hi,

I'm an intermediate level excel user that has not had much experience
in writing formulas. I am wondering whether the following is possible:

I will has a centralised excel file with a list of items which will be
updated frequently. Each item will contain a unique ID, a description
etc.

I will have another larger excel file that will contain the same type
data. Is there a formula that can compare the 2 files and highlight the
entire row of any item on the larger spreadsheet that appears on the
centralised file.

Any help would be greatly appreciated.


--
JustinKredible
------------------------------------------------------------------------
JustinKredible's Profile: http://www.excelforum.com/member.php...o&userid=36563
View this thread: http://www.excelforum.com/showthread...hreadid=563120