Remove #N/A Error
 

I am creating a spreadsheet where a user can select different categories
which then populate adjacent cells with information from a second hidden
sheet. Right now I am using this formula and want to remove the #N/A error
that appears when no category has been chosen:

=IF(ISBLANK((VLOOKUP(D11,mmtable,3,FALSE))),((VLOO KUP(D11,mmtable,2,FALSE)))*E11,((VLOOKUP(D11,mmtab le,3,FALSE))*E11)+(VLOOKUP(D11,mmtable,2,FALSE)))

I have seen solutions for this along the lines of
=IF(ISNA(formula),""(formula)) but I do not think this will work for me since
I need to keep the both the "if true" and "if false" parts of mine. Any help
would be greatly appreciated.

Remove #N/A Error
 

=IF(ISNA(VLOOKUP(D11,mmtable,3,FALSE)),"",IF(ISBLA NK(VLOOKUP(D11,mmtable,3,FALSE)),VLOOKUP(D11,mmtab le,2,FALSE)*E11,VLOOKUP(D11,mmtable,3,FALSE)*E11+V LOOKUP(D11,mmtable,2,FALSE)))

will work, since looking up D11 in the mmtable and returning an #N/A will
bomb out any of the following statementsm this will default to ""
immediately. If no N/A, then it goes through the nested IF statements. I also
removed extraneous parentheses.

"kmp09" wrote:

I am creating a spreadsheet where a user can select different categories
which then populate adjacent cells with information from a second hidden
sheet. Right now I am using this formula and want to remove the #N/A error
that appears when no category has been chosen:

=IF(ISBLANK((VLOOKUP(D11,mmtable,3,FALSE))),((VLOO KUP(D11,mmtable,2,FALSE)))*E11,((VLOOKUP(D11,mmtab le,3,FALSE))*E11)+(VLOOKUP(D11,mmtable,2,FALSE)))

I have seen solutions for this along the lines of
=IF(ISNA(formula),""(formula)) but I do not think this will work for me since
I need to keep the both the "if true" and "if false" parts of mine. Any help
would be greatly appreciated.

Remove #N/A Error
 

This works perfectly. Thank you so much!

"Sean Timmons" wrote:

=IF(ISNA(VLOOKUP(D11,mmtable,3,FALSE)),"",IF(ISBLA NK(VLOOKUP(D11,mmtable,3,FALSE)),VLOOKUP(D11,mmtab le,2,FALSE)*E11,VLOOKUP(D11,mmtable,3,FALSE)*E11+V LOOKUP(D11,mmtable,2,FALSE)))

will work, since looking up D11 in the mmtable and returning an #N/A will
bomb out any of the following statementsm this will default to ""
immediately. If no N/A, then it goes through the nested IF statements. I also
removed extraneous parentheses.

"kmp09" wrote:

I am creating a spreadsheet where a user can select different categories
which then populate adjacent cells with information from a second hidden
sheet. Right now I am using this formula and want to remove the #N/A error
that appears when no category has been chosen:

=IF(ISBLANK((VLOOKUP(D11,mmtable,3,FALSE))),((VLOO KUP(D11,mmtable,2,FALSE)))*E11,((VLOOKUP(D11,mmtab le,3,FALSE))*E11)+(VLOOKUP(D11,mmtable,2,FALSE)))

I have seen solutions for this along the lines of
=IF(ISNA(formula),""(formula)) but I do not think this will work for me since
I need to keep the both the "if true" and "if false" parts of mine. Any help
would be greatly appreciated.

Remove #N/A Error
 

No problem! Thank you for the feedback!

"kmp09" wrote:

This works perfectly. Thank you so much!

"Sean Timmons" wrote:

=IF(ISNA(VLOOKUP(D11,mmtable,3,FALSE)),"",IF(ISBLA NK(VLOOKUP(D11,mmtable,3,FALSE)),VLOOKUP(D11,mmtab le,2,FALSE)*E11,VLOOKUP(D11,mmtable,3,FALSE)*E11+V LOOKUP(D11,mmtable,2,FALSE)))

will work, since looking up D11 in the mmtable and returning an #N/A will
bomb out any of the following statementsm this will default to ""
immediately. If no N/A, then it goes through the nested IF statements. I also
removed extraneous parentheses.

"kmp09" wrote:

I am creating a spreadsheet where a user can select different categories
which then populate adjacent cells with information from a second hidden
sheet. Right now I am using this formula and want to remove the #N/A error
that appears when no category has been chosen:

=IF(ISBLANK((VLOOKUP(D11,mmtable,3,FALSE))),((VLOO KUP(D11,mmtable,2,FALSE)))*E11,((VLOOKUP(D11,mmtab le,3,FALSE))*E11)+(VLOOKUP(D11,mmtable,2,FALSE)))

I have seen solutions for this along the lines of
=IF(ISNA(formula),""(formula)) but I do not think this will work for me since
I need to keep the both the "if true" and "if false" parts of mine. Any help
would be greatly appreciated.