View Table based on drop down list selection

Just a slight change to Bo's formula in B21:

=IFERROR(INDEX(INDIRECT($AG$1),ROWS($1:1))&"","")

then you can copy it down your yellow area.

Hope this helps.

Pete

Pete_UK & Bo_Ry,
Thanks very much.

both solutions work perfectly!

I'd spent a few hours looking online for a solution and didn't get anywhere, so your help is very much appreciated!
cheers
vin