IF HELP

S

Snailspace

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

ryguy7272

The easiest way would be to use a Pivot Table. It would take about 5-10
seconds to get the results you want. See this link for info:
http://www.cpearson.com/excel/pivots.htm

Place all your date elements in the Row field. Double-click each field (at
the top of the Row) and choose Subtotals > None > Ok. If it doesn't work
for you at first, try a couple times. I know it works. it is a little
tricky the first couple times you deal with it though...

Regards,
Ryan---
 
S

Sheeloo

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

ryguy7272

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---
 
R

rspowell

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!
Click to expand...


Christine --

Try something like this ...

=IF(VLOOKUP("My Criteria",A:B,2,FALSE)=0," ",VLOOKUP("My Criteria",A:B,
2,FALSE))


Hope it helps you !

- Rodney POWELL
Microsoft MVP - Excel

www.BeyondTechnology.com
 
Top