Extract & Display Data from a list to a table

[Brightspark98]

Can anyone help with the following.

I want to extract the names of people from the list and place them in their corresponding place on the table to the right.

Thank you.

Name	Day		Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
Laurel	Monday
Jerold	Tuesday		names go here	names go here	names go here	names go here	names go here	names go here	names go here
Booker	Wednesday		names go here	names go here	names go here	names go here	names go here	names go here	names go here
Andres	Thursday		names go here	names go here	names go here	names go here	names go here	names go here	names go here
Desire	Friday
Roseanne	Saturday
Tatyana	Sunday
Brunilda	Monday
Saundra	Tuesday
Pauline	Wednesday
Marquis	Thursday
Roni	Friday
Celia	Saturday
Danica	Sunday
Elvis	Monday
Cedrick	Tuesday
Jeniffer	Wednesday
Regenia	Thursday
Geraldine	Friday
Harry	Saturday
George	Sunday

<tbody>
</tbody>

 

[123rickfear]

=INDIRECT("A"&SMALL(IF($B$1:$B$100=C$1,ROW($A$1:$A$100)),ROW(1:1)))

confirm with ctrl + shift + enter

drag across and down.

 

[Brightspark98]

As if by magic my spreadsheet springs to life!!

Thanks for your help, works like a dream.