find date that matches date on my sheet and copy from table below.

You can use a formula like this, say in D1, to find where the date occurs in column B of the main sheet:

=IFERROR(MATCH(TEXT($B$1,"dd/mm/yyyy"),'sheet 1'!B:B,0),"")

Then you can use these formulae in the cells stated:

B9: =IF($D$1="","",INDEX('sheet 1'!C:C,$D$1+3))

B10: =IF($D$1="","",INDEX('sheet 1'!C:C,$D$1+4))

and copy these across for the other days.

Hope this helps.

Pete

Originally Posted by Pete_UK

You can use a formula like this, say in D1, to find where the date occurs in column B of the main sheet:

=IFERROR(MATCH(TEXT($B$1,"dd/mm/yyyy"),'sheet 1'!B:B,0),"")

Then you can use these formulae in the cells stated:

B9: =IF($D$1="","",INDEX('sheet 1'!C:C,$D$1+3))

B10: =IF($D$1="","",INDEX('sheet 1'!C:C,$D$1+4))

and copy these across for the other days.

Hope this helps.

Pete

Thanks, genius!!!!

Thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete