Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Hiding" formulas
Hi,
I'm using the vlookup function for a spreadsheet and have copied my formula down the bottom of the page. So now, those cells show #N/A because I have not yet entered the vendor information into the first column to populate the other columns. Is there a way to hide those #N/ A's so I don't have to see them? I tried protecting and hiding those cells, but it didn't work like I had hoped. Any suggestions? Thanks, Veronica |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Hiding" formulas
hi, Veronica,
try to use: if(iserror(vlookup(.......),""),vlookup(.......... .)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Veronica Johnson" escreveu: Hi, I'm using the vlookup function for a spreadsheet and have copied my formula down the bottom of the page. So now, those cells show #N/A because I have not yet entered the vendor information into the first column to populate the other columns. Is there a way to hide those #N/ A's so I don't have to see them? I tried protecting and hiding those cells, but it didn't work like I had hoped. Any suggestions? Thanks, Veronica |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Hiding" formulas
On Jan 9, 1:28*pm, Marcelo wrote:
hi, Veronica, try to use: if(iserror(vlookup(.......),""),vlookup(.......... .)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Veronica Johnson" escreveu: Hi, I'm using the vlookup function for a spreadsheet and have copied my formula down the bottom of the page. *So now, those cells show #N/A because I have not yet entered the vendor information into the first column to populate the other columns. *Is there a way to hide those #N/ A's so I don't have to see them? I tried protecting and hiding those cells, but it didn't work like I had hoped. *Any suggestions? Thanks, Veronica- Hide quoted text - - Show quoted text - Hi, it told me that there were too many arguments entered. Any other suggestions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Hiding" formulas
See if this works:
if(iserror(vlookup(.......)), "", vlookup(...........)) CW "Veronica Johnson" wrote: On Jan 9, 1:28 pm, Marcelo wrote: hi, Veronica, try to use: if(iserror(vlookup(.......),""),vlookup(.......... .)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Veronica Johnson" escreveu: Hi, I'm using the vlookup function for a spreadsheet and have copied my formula down the bottom of the page. So now, those cells show #N/A because I have not yet entered the vendor information into the first column to populate the other columns. Is there a way to hide those #N/ A's so I don't have to see them? I tried protecting and hiding those cells, but it didn't work like I had hoped. Any suggestions? Thanks, Veronica- Hide quoted text - - Show quoted text - Hi, it told me that there were too many arguments entered. Any other suggestions? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Hiding" formulas
Veronica
Try similar to this =IF(ISNA(VLOOKUP(G2,$C$1:$F$31,2,FALSE)),"",VLOOKU P(G2,$C$1:$F$31,2,FALSE)) ISNA is preferable to ISERROR because ISERROR masks any and all errors. Gord Dibben MS Excel MVP On Wed, 9 Jan 2008 10:40:47 -0800 (PST), Veronica Johnson wrote: On Jan 9, 1:28*pm, Marcelo wrote: hi, Veronica, try to use: if(iserror(vlookup(.......),""),vlookup(.......... .)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Veronica Johnson" escreveu: Hi, I'm using the vlookup function for a spreadsheet and have copied my formula down the bottom of the page. *So now, those cells show #N/A because I have not yet entered the vendor information into the first column to populate the other columns. *Is there a way to hide those #N/ A's so I don't have to see them? I tried protecting and hiding those cells, but it didn't work like I had hoped. *Any suggestions? Thanks, Veronica- Hide quoted text - - Show quoted text - Hi, it told me that there were too many arguments entered. Any other suggestions? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Hiding" formulas
I think Marcelo may have intended to say:
=if(iserror(vlookup(.......)),"",vlookup(......... ..)) -- David Biddulph "Veronica Johnson" wrote in message ... Hi, it told me that there were too many arguments entered. Any other suggestions? On Jan 9, 1:28 pm, Marcelo wrote: hi, Veronica, try to use: if(iserror(vlookup(.......),""),vlookup(.......... .)) Marcelo "Veronica Johnson" escreveu: Hi, I'm using the vlookup function for a spreadsheet and have copied my formula down the bottom of the page. So now, those cells show #N/A because I have not yet entered the vendor information into the first column to populate the other columns. Is there a way to hide those #N/ A's so I don't have to see them? I tried protecting and hiding those cells, but it didn't work like I had hoped. Any suggestions? Thanks, Veronica |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Hiding" formulas
On Jan 9, 2:11*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Veronica Try similar to this * * =IF(ISNA(VLOOKUP(G2,$C$1:$F$31,2,FALSE)),"",VLOOKU P(G2,$C$1:$F$31,2,FALSE)) ISNA is preferable to ISERROR because ISERROR masks any and all errors. Gord Dibben *MS Excel MVP * On Wed, 9 Jan 2008 10:40:47 -0800 (PST), Veronica Johnson wrote: On Jan 9, 1:28*pm, Marcelo wrote: hi, Veronica, try to use: if(iserror(vlookup(.......),""),vlookup(.......... .)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Veronica Johnson" escreveu: Hi, I'm using the vlookup function for a spreadsheet and have copied my formula down the bottom of the page. *So now, those cells show #N/A because I have not yet entered the vendor information into the first column to populate the other columns. *Is there a way to hide those #N/ A's so I don't have to see them? I tried protecting and hiding those cells, but it didn't work like I had hoped. *Any suggestions? Thanks, Veronica- Hide quoted text - - Show quoted text - Hi, it told me that there were too many arguments entered. *Any other suggestions?- Hide quoted text - - Show quoted text - Hi Gentleman, Thank you so much! Both these options worked perfectly! I appreciate your help. -Veronica |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Formulas when the value is "0"? | Excel Discussion (Misc queries) | |||
Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
hiding formulas with "Grouped' columns | Excel Discussion (Misc queries) | |||
Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel |