How to populate automatically a value depending on the previous drop down cell

[zazu8]

Hi, I am working on a database and I have a list of people's names and a list of their nicknames. When selecting the people's name from a drop down list in column B, I would like to have automatically the nickname of that person in column C and the city of residence in column D. Is it possible? Thank you

 

[Joe4]

If you have a list of the name, nickname, and city of residence, you should be able to use VLOOKUP or XLOOKUP formulas to return those values.
See: XLOOKUP function - Microsoft Support

 

[zazu8]

If you have a list of the name, nickname, and city of residence, you should be able to use VLOOKUP or XLOOKUP formulas to return those values.
See: XLOOKUP function - Microsoft Support

Thanks. It is exactly what I ws looking for

 

[Joe4]

You are welcome.
Glad I was able to help!