Excelquestion35
Board Regular
- Joined
- Nov 29, 2021
- Messages
- 53
- Office Version
- 2016
- Platform
- Windows
Hi all,
For a project I need to retrieve all supervisor names belonging to a certain customer in a sort of list view. The retrieved values serve as input for a drop down list.
I tried using VLOOKUP but then I will retrieve only the first value, but actually I need all separate values in multiple cells (amount is equal to the amount of unique supervisors)
I tried the following:
D1 is the name of the customer
Column B are all customer names in another file
Column C are all supervisor names in another file
Any idea how I can achieve this?
For a project I need to retrieve all supervisor names belonging to a certain customer in a sort of list view. The retrieved values serve as input for a drop down list.
I tried using VLOOKUP but then I will retrieve only the first value, but actually I need all separate values in multiple cells (amount is equal to the amount of unique supervisors)
I tried the following:
Excel Formula:
=VLOOKUP($D$1;'[Site overview (1).xlsx]FLMs'!$B:$C;2;FALSE)
D1 is the name of the customer
Column B are all customer names in another file
Column C are all supervisor names in another file
Any idea how I can achieve this?