Show information from database in a list

Good Morning

I have a database which shows a list of names and training documents each person requires. I am looking for a way where I can select a name and it will automatically show me the documents that person requires in a list

the attachment shows a small example of what I am looking for

List Training Docs.xls

Cheers

Jim

Is this what you are looking for?

Here's another way using one helper column (AH) and an array formula in Column AI.
I hve added two dynamic named ranges, they are linked, so you can "grow" your table.

Hope this helps

non array method still uses a helper row tho, probably a tad more efficient and easier to reproduce!

@ martindwilson nice one!
Probably a combination of your workbook and this will be best

@ JamesT1
Try this

I have changed the layout of your sheet to make it easier to maintain

In Row 1
in D1

=COLUMN(A1)

Drag Right for 80 columns

This will now be used to dynamically resize the width of your table

In the names manager
"Names" remains unchanged
Refers to:=

=OFFSET(Sheet1!$C$6,0,0,MATCH("*",Sheet1!$C:$C,-1)-5,1)

"ReqdDocs" becomes
Refers to:=

=OFFSET(Sheet1!$D$6,0,0,MATCH("*",'List Training Docs.xls'!Names,-1),MAX(Sheet1!$1:$1))

Match refers to the length (Last Row) of the named list "Names" this keeps both lists the same length.
The Max function (Table Width) now makes the width of the table dynamic, delete from the end of row 1 and the table width will decrease, drag it further and the width will grow.

You could of course just put a value in a fixed cell and achieve the same, I just thought column numbers might be handy.

The Helper column formula becomes (Now Column A)
In A6

=IF(ROW()-6>=MAX($1:$1),"",IF(INDEX(ReqdDocs,MATCH($B$5,Names,0),ROW(A1))="y",OFFSET(INDEX(ReqdDocs,MATCH($B$5,Names,0),ROW(A1)),-MATCH($B$5,Names,0),0),""))

This is the same as before but nested in an IF statement to avoid the #REF! error if the formula is dragged past the length that coresponds to the width of the main table.

I have changed your conditional formatting to use a formula

=AND($C6<>"",D6<>"y",D$1<>"")

and added

=AND(D$1<>"",D6<>"y",$C6<>"")

Both apply to

=$D$6:$GT$1006

That will allow your table to format as it grows in length up to 1000 rows, and the width up to 200 columns.

Hope this helps.

blimey id just use my method and change the range sizes it already caters for c.200 rows

hey i didnt even notice the cf part lol