Use lookup or ??

J

JayL

All -
I'm trying to get a function to return a Y or N if the contents of sheet2
cell A1 matches any cell in sheet1 column A.
TIA
-Jay
 
M

Max

One way ..
Put in Sheet2's B1 (say):
=IF(A1="","-",IF(ISNUMBER(MATCH(A1,Sheet1!A:A,0)),"Y","N"))
B1 can be copied down to return correspondingly for other values in A2, A3,
etc
 
A

Ashish Mathur

Hi,

You may try the following array formula (Ctrl+Shift+Enter) in cell B1 of
sheet 2

=if(or(exact(A1,sheet1_range))

Regards,

Ashish Mathur
 
Top