Hi All,
I'm trying to work out how to return data from 4 columns in one worksheet depending on what I input into a cell in another worksheet (same workbook)
Essentially I want the user to be able to input a date and for the 4 columns below that date (in another worksheet) to be displayed.
There are 14 dates involved so I can't just use embedded if formulas.
Any help would be greatly appreciated.
I have attached an example file to assist.
In 'Daily Roster'!, I'd like the user to type in the date in B1 and then the roster from 'Cat A'! to return the values I have input there.
Bookmarks