After viewing the following guide (http://office.microsoft.com/en-us/ex...005209118.aspx), I'm still having troubles creating if-then statements for a model I've been trying to construct. I need to test more than seven conditions, and need to use cells from different sheets as well - the LOOKUP function looks like it would get the job done. However, I keep running into errors. This is the current format I've been trying:

=LOOKUP(A1,{1,2,3},{'Sheet1'!A1,'Sheet1'!A2,'Sheet1'!A3})

Where A1 is the cell accepting the conditional value, {1,2,3} are the conditional values, and {'Sheet1'!A1,'Sheet1'!A2,'Sheet1'!A3} are three cells from a different sheet that should be returned (these correspond with the three values).

What am I doing wrong? I've been searching for a good amount of time on this site and the Internet, and have found nothing useful. I don't know any VBA but if this could be solved using it then I'd be willing to give it a try.