"RaymundCG" skrev i en meddelelse
...
Hi Rick!

I re-tested the formula and it seems that this one may be better... :)

=IF(OR(G2=0,G2=""),"",VLOOKUP(G2,$C$30:$F$369,2))

Hope this helps!
--

Hi Raymund

This in an example of De Morgan's Laws, which has to do with
negating propositions.

If you negate the compound proposition
G2=0 OR G2=""

De Morgan states, that the propositions are negated and OR
is turned to AND (and vice versa), so

neg(G2=0 OR G2="") will be
G2<0 AND G2<""

Or in your first answer:

=IF(AND(G2<0,G2<""),VLOOKUP(G2,$C$30:$F$369,2)," ")

--
Best regards
Leo Heuser

Followup to newsgroup only please.