View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Use lookup or ??

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JayL" wrote in message
...

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