If you post the formula that isn't working, you'll likely get a custom,
working formula back....
otherwise, you'll receive a generic formula that may or may not solve your
problem.


***********
Regards,
Ron

XL2002, WinXP


"Honey" wrote:

Hello

Here is the problem - If cell A1 has 0 then I want B1 to be
0...however if A1= 1 I want B1 to display the result from a look up
table.

I just keep getting error messages and I am ready to chuck the
Computer out of the window.....I am using Office Excel on Mac but that
does not normally make a difference to formulas.

Thank you!!

Lyndsey