Hi!
Could you please advise on a formula for a data validation that returns multiple values depending on multiple criteria?
Each cell in column B is a drop down, thus I need B5 to return list of Cities (City 1, City 2, City 3 and so on) or Villages depending criteria I choose in each of above cell.
Could you please advise on a formula for a data validation that returns multiple values depending on multiple criteria?
Each cell in column B is a drop down, thus I need B5 to return list of Cities (City 1, City 2, City 3 and so on) or Villages depending criteria I choose in each of above cell.