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

=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

Hi,

Im new to this site but think I maybe able to help.

I would suggest on Sheet 2 to putting the following formula in column C, and
as your lookup formula to report column 3.

=+IF(B2="","","Y")

If you are already using colulm C, you could always insert then hide the
column.

"JimS" wrote:


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.

Im trying to use a VLOOKUP (=vlookup(a1, Sheet2 A:B, 2, False) on
Sheet1 but cant 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