Hello,
I have an excel sheet that has a number of lists (validated with a list) (all containing the same data range which is courses). When a option is selected the following formula fills in the price field "=LOOKUP(D8,courses,data!C2:C15)". I also have a field at the end that calculates the sum of all the prices and adds VAT. However if one or more of the lists does not have anything selected then "#N/A" is in the price area and so the sum formula does not work. It is likely that not all the lists will have anything selected.
Is there something I can do so that if nothing is selected then a zero is returned? Or can you have the first item in a range already selected e.g. "please pick from list" and the price for this wold be zero. Or is there a better way of doing this? I only have medium experience with Excel so any suggestions would be hugely appreciated!
Hope that all make sense!
Red
contact
us
