K
kmp09
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))),((VLOOKUP(D11,mmtable,2,FALSE)))*E11,((VLOOKUP(D11,mmtable,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.
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))),((VLOOKUP(D11,mmtable,2,FALSE)))*E11,((VLOOKUP(D11,mmtable,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.