Vlookup - Maybe?

[JimS]

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Guest]

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.