=IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"",IF(INDEX(Sheet 2!B:B,MATCH(A1,Sheet2!A:A,
0))="","","Y"))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"JimS" wrote in message
...

Here' my challenge.

I have a single workbook that I use several sheets as input for a
Summary Sheet.

Let use Sheet1 as the summary sheet and Sheet2 as an input sheet.

Sheet1 - Column A has hundreds of names
Sheet2 - Column A has hundreds of names (some of which are on Sheet1 -
Column A)
Sheet2 - Column B has dates of when the individual completed a Task.
I need to put a "Y" in Sheet1 - Column B if there is a Date in Column B
on Sheet2 for each matching name in Column A.

I'm trying to use a VLOOKUP (=vlookup(a1, Sheet2 A:B, 2, False) on
Sheet1 but can't figure out how to return a "Y" instead of the Date
(column B on Sheet2).

Any ideas?

As always, Thanks, this group has never let me down.

Jim


--
JimS
------------------------------------------------------------------------
JimS's Profile:
http://www.excelforum.com/member.php...fo&userid=9876
View this thread: http://www.excelforum.com/showthread...hreadid=542095