Try the formula I've just posted and fill it down the column. Does that give
you the result you want?

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" ON SHEET 1 IN CEL B1 AND B3 BECAUSE 123 ON SHEET 1 IN
A1 AND A3 ARE LISTED ON SHEET 2.

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