see other thread

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Honey" wrote in message
ups.com...
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