Typo

=IF(ISNUMBER(MATCH(A2,Sheet2!A:A,0)),"a","")

--
HTH

Bob Phillips

"Bob Phillips" wrote in message
...
Assuming the PCs are both in column A, on the first

B2: = IF(ISNUMBER(MATCH(A2,Sheet2!A:A,0)),"a",""

format B2 as Marlett, and copy down.

--
HTH

Bob Phillips

"John" wrote in message
...
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