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

"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!