Data Validation and Vlookup

Good day,

Please I want to know if data validation(with the drop down) and vlookup(referencing another spreadsheet) can work on the same cell. i.e when you drop down a value, and select, it automatically changes to another value that has been referenced by the lookup function.

Originally Posted by alansidman

The Vlookup can use the data validation cell as its criteria if that is what you are asking and return the result to another cell where the Vlookup formula is located.

Thanks Alan, what I want to know is if the vlookup formula can return the result to the data validation cell that it used as the criteria.

Have a look at this example. I think this is what you mean?