ExcelBanter - I want to populate the role of the person,when i select the name

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I want to populate the role of the person,when i select the name (https://www.excelbanter.com/excel-worksheet-functions/128505-i-want-populate-role-person-when-i-select-name.html)

Simi

I want to populate the role of the person,when i select the name

When i select one person's name, I want to populate their role from a
selected table.

How can this be done in excel?

Stefi

I want to populate the role of the person,when i select the name

Have a look at VLOOKUP or MATCH, INDEX functions depending on arrangements of
your columns!

Regards,
Stefi

€žSimi€ ezt Ã*rta:

When i select one person's name, I want to populate their role from a
selected table.

How can this be done in excel?

All times are GMT +1. The time now is 07:41 AM.