Dashboard help - need figures to be linked/imported when making a selection

Hi guys,

I am attaching a dashboard with fictional names.

Can someone please help me with 'importing data' on my tab 'Dashboard' at the bottom where there is interviewer information. If I select an interviewer's name from the left-hand side (list) how can I import their details into the interviewer information? I.e. their name and start date etc? I am looking to pull the data from the 'Interviewer Data' tab.

Thank you.

hi there. for people to understand more easily, input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.

i am guessing if you choose "Micah Talia" for eg, you want to retrieve her name, Start Date, etc in Interviewer Data worksheet. type those down manually to show us. Also, this name appeared thrice in the worksheet. So which do you extract?

first, format cell D46 to General instead of Text

secondly, ensure field names in D46:D54 ties with the one in Interviewer Data worksheet row 1. for instance:
either Name or Full Name. don't use both
Comp or Completes. don't use both

if you simply want to extract the earliest entry on top, you can use just 1 formula in D46 and copy it down.

Formula:

Please Login or Register  to view this content.

if you don't wish to change the names, then do it 1 by 1. This extracts from the 1st column of Interviewer Data worksheet.
=INDEX('Interviewer Data'!$A:$U,MATCH(INDEX(Lists!$A$4:$A$99,Lists!$A$1,0),'Interviewer Data'!$A:$A,0),1)

2nd column (Date):
=INDEX('Interviewer Data'!$A:$U,MATCH(INDEX(Lists!$A$4:$A$99,Lists!$A$1,0),'Interviewer Data'!$A:$A,0),2)

Dates must be formatted as a date so that you don't see numbers.

Hi benishiryo

I have played around with the sheet as per your suggestions, and sorry if i was not clear, but yes if I select a name on the left-handside, list on the dashboard tab, I would like it to return data from the interviewer data tab. How can I get this to be linked (i.e. extract the data). Latest version attached.

Thank you!

Thanks so much John!