Forum Discussion
VLOOKUP: ARRANGE A SCHEDULE OF TASKS ON THE SAME DATE
Hi, I have a 2016 Excel for Mac and want to organise a day schedule picking datas from a month one (both in the same worksheet). So far I could make it work with only one task per day.
If my lookup_value is a date, how do i manage to have all the tasks and put them in an increasing time order on the same table?
Any help is more than welcome!
Paolo
Hi paoloambro
Please see attached the updated worksheet.
I converted the data range to a table named "Data" and I used the following formula.
{=IFERROR(INDEX(Data, SMALL(IF($DE$2=Data[DATE], ROW(Data[TIME])-ROW(Data[[#Headers],[TIME]])), ROW(1:1)),4),"" )}entered as array pressing Ctrl+Shift+Enter.
Cheers,
11 Replies
Hi paoloambro
VLOOKUP will only return 1 entry.
The better approach will be to use INDEX, MATCH, SMALL & ROW functions.
If you can share the file with dummy values, that will be easier to work with.
Cheers,
Hi wumolad
thank you for getting back to me.
Pls find in the attachment the file which includes:
- the source (CO is the first column
- the week days into i need to order all the tasks, day by day
Should you need further info, just let me know.
Thank you so much!
Paolo
Hi paoloambro
Please see attached the updated worksheet.
I converted the data range to a table named "Data" and I used the following formula.
{=IFERROR(INDEX(Data, SMALL(IF($DE$2=Data[DATE], ROW(Data[TIME])-ROW(Data[[#Headers],[TIME]])), ROW(1:1)),4),"" )}entered as array pressing Ctrl+Shift+Enter.
Cheers,
