IF HELP

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

 

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

 

[Sheeloo]

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

 

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

 

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

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

 

[Snailspace]

YOU ROCK!! That worked! I'm getting where I need to be!

Thanks for your help.

 

[ryguy7272]

Please click 'Yes', if the post was helpful to you.