=IF(A1<1,0,VLOOKUP(lookup_value,lookup_table,2,0) )


adapt to fit


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"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