Lookup Date in Table & Display Cell Information

Hi,

I've been trying to solve this for a while and if someone can help me it would be greatly appreciated.

I have a table of information on 'Summary' tab.

I have created a 'Calendar' tab. Cell1 in each column has the date. Under each column from Cell2 I would like to lookup the table on 'Summary' tab for the matching date in ColumnD and then return the matching value in ColumnJ.

I would also like to take the start date and end date and ensure it merges across the correct days on Calendar tab.

I also want to avoid blank cells and entries on the following day appearing in later rows....obviously if an entry spans multiple days this is probably not avoidable.

I think I am close.....but in theory I am probably miles away!!!

Have uploaded the example file.

Many Thanks for anyone who can help me solve this.

Jay

Your file seems to have not made it, please reload it

Try this in B2 of Calendar tab:

Formula:

Please Login or Register  to view this content.

Drag down and across

In attachment, I have added a formula in Column A, just to show what that row is displaying oinfo about, this can be removed
In the Summary tab, I changed the 5'th item's end date to show 5 days in a row

Hope this helps

Edit-

Looks like your attachment did show up in first post after all, but after I had read the post ..sorry about that

1) by no end date, do you mean you want it open ended? (ie- cr in use until further notice--end day is finally set), or just gets set for the start date?
2) that would be done through formatting, not within the formula itself, and I would recomend against merging, if you ever need to refernce the data in the calendar, it becomes a nightmare !
if you really wanted to, I suppose you could do something like "center across selection' but again, if you ever need to reference the data, it becomes a hassle...

sorry..was a vague question...I meant if there is no end date set, does the information just display in the first date, or does it carry on until there is an end date set?

Try this in B2

Formula:

Please Login or Register  to view this content.

drag across and down

Hope this helps

Edit-
It was my poor wording of original question that caused the confusion, so no worries

You are quite welcome !

Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"