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
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
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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
>
Hi Jay
One way
=IF(ISNA(MATCH(Sheet2!A1,Sheet1!A:A,0)),"N","Y")
--
Regards
Roger Govier
"JayL" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
Perfect! Thanks!
"JayL" <[email protected]> wrote in message
news:[email protected]...
>
>
> 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
>
>
>
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
"JayL" wrote:
>
> 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
>
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks