Maybe this:
=IF(A2=0,"",VLOOKUP($A2,'Services Data'!$1:$65536,COLUMNS($A$2:K2),FALSE))

Also, if you want to show or hide Zeros, try this: Tools Options View
Zero Values (check or uncheck).

Regards,
Ryan---
--
RyGuy


"Snailspace" wrote:

I created a VLOOKUP formula for a spreadsheet but I want to include an
IF statement - I think - so that if the value=0 then there is only a
space included. I don't want the 0's showing in my report.

=VLOOKUP($A2,'Services Data'!$1:$65536,COLUMNS($A$2:K2),FALSE)

THANKS!