=VLOOKUP(IF(ISNUMBER((E15)*1),(E15)*1,(E15)),pax,12,FALSE)+VLOOKUP(IF(ISNUMBER((E16)*1),(E16)*1,(E16)),pax,12,FALSE)
The formula takes cells E15-E21 just not shown here for simplicity.
What can I add to the formula so if cells 16-21 are blank it won't return a #N/A?
thanks
The formula takes cells E15-E21 just not shown here for simplicity.
What can I add to the formula so if cells 16-21 are blank it won't return a #N/A?
thanks