Excel if statements

[Borzoi]

Is there a way to have multiple conditions using some sort of "or" so that I don't have to nest so many if statements?

I currently have cells like this:

=IF(E2 = "District1","North",IF(E2 = "District2","North",IF(E2 = "District3","North",IF(E2 = "District4","North","Not North"))))

I have tried using OR in two ways and neither work.

=IF(E2 = "District1" OR E2 = "District2" OR E2 = "District3" OR E2 = "District4","North","Not North")

=IF(E2 = "District1" OR "District2" OR "District3" OR "District4","North","Not North")

Is there some kind of "or" conditional or do I have to keep with my long winded nested ifs?

EDIT: It turns out I have too many nested If statements for Excel to handle. It seems Excel only accepts 8 nested IF statements (despite the help saying that I can have up to 64).

[CimmerianX]

I think a VLookup might be what you are looking for....

http://spreadsheetpage.com/index.php/tip/alternatives_to_nested_if_functions/
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm

[Borzoi]

Ah yes, thank you. That has solved the problem.