"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?
|