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