Is there a way to output specific rows based on dropdown option?

[OliverBoardman]

I am creating a Training record spreadsheet for my organisation, and I am trying to find out if there is a way to use a dropdown list to specify which row I want to pull data from my main table....

Table where I would input dates for training completed

Above Images (apologies for poor quality) are to try and show what I am aiming for visually, I can and will create a blank copy for the purposes of uploading to here if anyone is willing to try and lend me a hand!

(Had to censor out staff names for confidentiality)

The Dropdown on the smaller image includes a list of ALL the staff members I am trying to capture training records for (which is provided by Data Validation from the "Full list of staff" [first image])

The hope is that there is a way to select a name using the dropdown, and then for all of the applicable data to be shown in the row below?

I had previously thought I could just make a table like the one in the first image and then just use the filter function but I would like to find something cleaner/smoother than that if possible, as the intention is for this to be technophobe friendly!!

[#2]

Why not add a slicer to the table?

[#3]

Hi Jan,

Is a slicer different to the filter function of normal tables?

[#4 · Accepted solution]

See: https://jkp-ads.com/articles/slicers.asp (the article is about pivot table slicers, but table slicers behave the same)

[#5]

Hi Jan,

After a bit of googling this morning, this has been a great solution to my problem!
Thank you for the suggestion!, I've managed to create a slicer that filters by staff name and I have locked it to the cell that should have the dropdown, so it doesn't look too amiss! 😄

[#6]

@OliverBoardman Thanks. It is helpful for others if you mark my reply as the answer to your question.