if then else question

[steven_wonder]

I need to run an if then else statment that tests thru 420 values of data (420) times ? Does anyone know how I can do thisand if not - is there any spreadsheet program out there that has a lager than 7 limit for if then else statements ?

[davesexcel]

How about Setting up a table and using a vlookup function

What kind of conditions are you looking for

[steven_wonder]

I think I figured out a solution to the problem - thank you