day & column data

[janger-heli]

I am trying to report data relating to a day of the week

On the sheet attached I want to report on the Number in column A to day column c and report what collect (collect sheet) its on for that day in column
D

Hope that makes sense

[NBVC]

Try:

=INDEX(collect!$A$1:$H$10,MATCH(A2,collect!$A$1:$A$10,0),MATCH(C2,collect!$B$1:$H$1,0))

copied down

[Cheeky Charlie]

D2=INDEX(collect!B$2:H$10,MATCH(A2,collect!A$2:A$10,0),MATCH(C2,collect!B$1:H$1,0))

copy down

HTH

[Cheeky Charlie]

*snap!* 890