Your a genius. It works great. Many thanks.

"RaymundCG" wrote:

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!
--
Thanks and kind regards


"Rick" wrote:

Apologies: It works if there is nothing in the box, but not if there is a
zero in the box, and I can work with it like that, many thanks.

Rick

"Rick" wrote:

Hi RaymundCG
Thanks for the reply. Unfortunately this aolution did not work. Is there
anything else that I could try.
Rick

"RaymundCG" wrote:

Hi Rick!

Would this modification do?

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

Hope this helps!
--
Thanks and kind regards


"Rick" wrote:

=VLOOKUP(G2,$C$30:$F$369,2)
I have managed to create a look up table using the office assistant, and the
formula above dumps information into cell G3. If G2 is empty or has a zero I
don't want G3 to have anything in it. At the moment it just keeps coming up
with #N/A
Can anyone tell me what formula I should be using please