If Statement - If false, then check next cell

[jamber17]

I'm creating a function that needs to find if a name in one cell (E3) matches a name in a list of cells. I have two formulas I've tried to use but neither is quite right.

Formula 1 could work, but it'll take forever to write all of the nested if statements (and it would be difficult to add new names to the list because you'd have to keep adding numbers and nested if statements. Is there a way to say that if E3 can't be found in A2, then it automatically checks the next cell (A3) and so on?

1. =IF(E$3=A2,A2,IF(E$3=A3,A3,IF(E$3=A4,A4)))...

Formula 2 could work, but I can't figure out how it would populate the correct cell if the statement was true (hence why it's bolded for now).

2. =IF(E$3=A2:A200,A2:A200,"ERROR")

If you have any other suggestions as well, I'd be more than happy to listen to them! Thanks!

 

[Joe4]

So basically, it looks like you just want to check to see if the value in E3 appears in the list A2:A200, and if it is, just return itself?
One way is like this:

=IF(COUNTIF($A$2:$A$200,E$3)>0,E$3,"ERROR")

This basically counts the number of times E3 is found in A2:A200. If that count is greater than 0 (meaning it has been found), return the value, else return "ERROR".