I am using the below to hide the #N/A when the cell is not used. However I
keep on getting the error message @you have to many arguements for this
function' and highlighting B7 and the beginning and FALSE at the end.

probably really simple solution - please help

=IF(ISNA(LOOKUP(B7,Processes!$B$5:$B$150,Processes !$C$5:$C$150,FALSE)),"",LOOKUP(B7,Processes!$B$5:$ B$150,Processes!$C$5:$C$150,FALSE)))

thanks
Lisa

Well, you do have an extra bracket at the end - you should have the
same number of open and closed brackets (parentheses) in a formula.

Hope this helps.

Pete

On Nov 13, 3:30*pm, Lisa Cowan
wrote:
I am using the below to hide the #N/A when the cell is not used. However I
keep on getting the error message @you have to many arguements for this
function' and highlighting B7 and the beginning and FALSE at the end.

probably really simple solution - please help

=IF(ISNA(LOOKUP(B7,Processes!$B$5:$B$150,Processes !$C$5:$C$150,FALSE)),"",L*OOKUP(B7,Processes!$B$5: $B$150,Processes!$C$5:$C$150,FALSE)))

thanks
Lisa

Maybe this:
=IF(ISNA(LOOKUP(B7,Processes!$B$5:$C$150,FALSE))," ",LOOKUP(B7,Processes!$B$5:$C$150,FALSE))

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Lisa Cowan" wrote:

I am using the below to hide the #N/A when the cell is not used. However I
keep on getting the error message @you have to many arguements for this
function' and highlighting B7 and the beginning and FALSE at the end.

probably really simple solution - please help

=IF(ISNA(LOOKUP(B7,Processes!$B$5:$B$150,Processes !$C$5:$C$150,FALSE)),"",LOOKUP(B7,Processes!$B$5:$ B$150,Processes!$C$5:$C$150,FALSE)))

thanks
Lisa

I have just tried this formula and the value error message displays.
This is a conversions quote spreadsheet with 4 columns Processes, Cost,
Customer and Total. If nothing is selcted in the Processes column then the
other 3 display the #N/A symbol. The processes list is generated by creating
a named list from another spreadsheet. The processes column doesn't display
the #N/A symbol as there is a blank cell where it sits when no selection. For
appearances sake I would prefere not to have the #N/A symbol displaying when
no selection as it looks messy.
Hope this makes it clearer what I am trying to do .

"ryguy7272" wrote:

Maybe this:
=IF(ISNA(LOOKUP(B7,Processes!$B$5:$C$150,FALSE))," ",LOOKUP(B7,Processes!$B$5:$C$150,FALSE))

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Lisa Cowan" wrote:

I am using the below to hide the #N/A when the cell is not used. However I
keep on getting the error message @you have to many arguements for this
function' and highlighting B7 and the beginning and FALSE at the end.

probably really simple solution - please help

=IF(ISNA(LOOKUP(B7,Processes!$B$5:$B$150,Processes !$C$5:$C$150,FALSE)),"",LOOKUP(B7,Processes!$B$5:$ B$150,Processes!$C$5:$C$150,FALSE)))

thanks
Lisa

Sorry for taking so long to get back to you but had a family emergancy.
If I take out a bracket at the end I get the error message saying 'I have to
many arguements' then it highlights the first FALSE and B7. Not to sure why
it is doing this.
thanks

"Pete_UK" wrote:

Well, you do have an extra bracket at the end - you should have the
same number of open and closed brackets (parentheses) in a formula.

Hope this helps.

Pete

On Nov 13, 3:30 pm, Lisa Cowan
wrote:
I am using the below to hide the #N/A when the cell is not used. However I
keep on getting the error message @you have to many arguements for this
function' and highlighting B7 and the beginning and FALSE at the end.

probably really simple solution - please help

=IF(ISNA(LOOKUP(B7,Processes!$B$5:$B$150,Processes !$C$5:$C$150,FALSE)),"",LÂ*OOKUP(B7,Processes!$B$5 :$B$150,Processes!$C$5:$C$150,FALSE)))

thanks
Lisa

.

Hope you get this before you wste your time - but I have fixed it. thanks
for your help

"ryguy7272" wrote:

Maybe this:
=IF(ISNA(LOOKUP(B7,Processes!$B$5:$C$150,FALSE))," ",LOOKUP(B7,Processes!$B$5:$C$150,FALSE))

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Lisa Cowan" wrote:

I am using the below to hide the #N/A when the cell is not used. However I
keep on getting the error message @you have to many arguements for this
function' and highlighting B7 and the beginning and FALSE at the end.

probably really simple solution - please help

=IF(ISNA(LOOKUP(B7,Processes!$B$5:$B$150,Processes !$C$5:$C$150,FALSE)),"",LOOKUP(B7,Processes!$B$5:$ B$150,Processes!$C$5:$C$150,FALSE)))

thanks
Lisa

Hope you get this before you waste your time - I have fixed it thanks for
your help

"Pete_UK" wrote:

Well, you do have an extra bracket at the end - you should have the
same number of open and closed brackets (parentheses) in a formula.

Hope this helps.

Pete

On Nov 13, 3:30 pm, Lisa Cowan
wrote:
I am using the below to hide the #N/A when the cell is not used. However I
keep on getting the error message @you have to many arguements for this
function' and highlighting B7 and the beginning and FALSE at the end.

probably really simple solution - please help

=IF(ISNA(LOOKUP(B7,Processes!$B$5:$B$150,Processes !$C$5:$C$150,FALSE)),"",LÂ*OOKUP(B7,Processes!$B$5 :$B$150,Processes!$C$5:$C$150,FALSE)))

thanks
Lisa

.