Hello.

I'm no expert on all this so please forgive the obvious :-)

I have a spreadsheet with 2 worksheets. The main sheet has several columns
that do SQL Lookups and populate columns with PC names dependent on
criteria. (Each column lists PCs with a software product installed. These
columns are dynamically updates agains an SMS 2003 reporting database.
(Replicated copy of live data, replicates weekly)

The front sheet also does an SQL Lookup of the database and lists all the
PCs SMS is aware of. I would like to put a tick (Wingdings 2 capital P!!)
against a PC name in the First tab if it has a given piece of software
installed.

So what I have is on one sheet a list of PCs and on the other a list of PCs
with given software installed. I want to compare the 2 lists and if a name
appears on both lists, tick a column on the front sheet. Each piece of
monitored software has a column on both the First and second sheets.

Can anyone give me any pointers on how to get this thing going? Has it
already been done? Is there a pre-existin formula or function that could do
this?

Any help greatly appreciated.

Regards,

John