SOLVED

Excel

Brass Contributor

If I have a list of names in column A on Sheet 1, how would I enter an automatic "y" in cell B2 in sheet 2 if I enter a name from the list on Sheet 1 in Cell A2 in sheet 2 and a "n" if it is a name not on the list?

3 Replies

@marty007 

That could be

image.png

Please check in attached file

best response confirmed by marty007 (Brass Contributor)
Solution
This works perfectly, thank you vey much. I never even heard of the ISNA function.

@marty007 , glad to help

1 best response

Accepted Solutions
best response confirmed by marty007 (Brass Contributor)
Solution
This works perfectly, thank you vey much. I never even heard of the ISNA function.

View solution in original post