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!

IF HELP
 

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

IF HELP
 

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

IF HELP
 

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!

IF HELP
 

On Mar 17, 12:50*pm, 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!


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

IF HELP
 

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

Thanks for your help.



On Mar 17, 2:30*pm, rspowell wrote:
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

IF HELP
 

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

--
RyGuy


"Snailspace" wrote:

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

Thanks for your help.



On Mar 17, 2:30 pm, rspowell wrote:
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