S
sue
Hi,
Not sure I'm going to explain this very well but here goes:
I have an input cell with a validation list to select a location (A2) & a
second cell with a validation list to select an office building (A3).
Depending upon these two responses two costs are are populated in my
spreadsheet using vlookup. I now would like to go one step further - on the
choice of the location I would like to only provide the list of office
buildings applicable to that location.
Not sure how easy this is to do but any help would be appreciated. Thanks.
Not sure I'm going to explain this very well but here goes:
I have an input cell with a validation list to select a location (A2) & a
second cell with a validation list to select an office building (A3).
Depending upon these two responses two costs are are populated in my
spreadsheet using vlookup. I now would like to go one step further - on the
choice of the location I would like to only provide the list of office
buildings applicable to that location.
Not sure how easy this is to do but any help would be appreciated. Thanks.