For each row in my worksheet I am referencing a column (the value represents an account id) in a formula, and I am trying to find a matching row to the account ids in Column A of another worksheet called Benefit. If the account id is found in the Benefit worksheet, I want to return a value of Y. If not I want it to return a value of N. Based on what I am reading I think I need to use the IF function.
Here’s an example of what I have coded on the 1st rows in cell in a blank cell where I want my value populated. C1 contains the account id in the current worksheet. The Benefit worksheet has a list of account ids in column A from rows 4 thru 49. Some of he account ids on the first worksheet may be found in the Benefit worksheet but some may not.
I am trying this formula but it returns an N value in all cases (whether found or not)
=IF(C1=Benefit!$A$4:$A$49,"Y","N")
If I point specifically to the cell that I know has the value in the Benefit worksheet, then I get my expected Y value.
=IF(C1=Benefit!$A$18,"Y","N")
Of course I want Excel to search for it and tell me if it’s found or not, versus me pointing to the cell. How can I accomplish this?
Bookmarks