Hi

Have a look at Chip's excellent site:
http://www.cpearson.com/excel/duplic...tractingCommon

Andy.

"JR573PUTT" wrote
in message ...

I am trying to reference location numbers on sheet 1 to location numbers
on sheet 2. If the location number is on sheet 1, I want to return a
value of 'Y' if the same location number is on sheet 2.

sheet 1
location fall 05
123 Y
456
678 Y

sheet 2
location
123
333
678

Location 123 and 678 are listed on sheet 2, therefore I want to return
the value of "Y".

It does not have to be a "Y", if it is easier, it can return a value of
"1".


--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile:
http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=520749