hi,
I have been trying to make this work with index and match for hours with no luck.
I have a table with names in column 1 and the date as row 1. The corresponding cells contain the data I want to link to in another sheet and display them by the data/date
Ex,
Name 01-Sep 02-Sep 03-Sep
bob A1 A1 "blank"
joe A2 "blank" A2
steve A3 A3 A3
I want it to display in another sheet with column 1 data and row 1 as date if the data has a match versus that date;
01-Sep 02-Sep 03-Sep
A1 X X
A2 X X
A3 X X X
The data is in list boxes.
Help would be appreciated, i have included the sheet.
Thanks
Bookmarks