Thread: IF HELP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Snailspace Snailspace is offline
external usenet poster
 
Posts: 11
Default IF HELP

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!