| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
