IF Function

  • Thread starter Thread starter Lisa Cowan
  • Start date Start date
L

Lisa Cowan

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
 
Maybe this
=IF(ISNA(LOOKUP(B7,Processes!$B$5:$C$150,FALSE)),"",LOOKUP(B7,Processes!$B$5:$C$150,FALSE))

HTH,
Ryan---
 
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 .
 
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
 
Hope you get this before you wste your time - but I have fixed it. thanks
for your help
 
Hope you get this before you waste your time - I have fixed it thanks for
your help
 
Back
Top