Hello,
I have "Sheet1"
Then "Sheet2",
The question marks are what I don't know what to include. Or may be this is the wrong approach
Assuming we are the 13-Oct-22 today, The results of "Sheet 2" am looking for is hereunder. The idea is to get a planning on sheet2 (from sheet1) as from Today the 13-Oct-22. However VLOOKUP may find more than 1 matched data, then it should have other results on other rows.
"Sheet2":
Thanks for any hint !
I have "Sheet1"
Company | Schedule | Date |
Microsoft | 2 hours (10h00-12h00) | 13-Oct-22 |
IBM | 4 hours (09h00-13h00) | 15-Oct-22 |
Dell | 3 hours (13h00-16h00) | 13-Oct-22 |
Then "Sheet2",
=TODAY() | =A1+1 | =B1+1 | =C1+1 |
=VLOOKUP(A1,Sheet1!A1:C4,????,FALSE) | =VLOOKUP(B1,Sheet1!A1:C4,????,FALSE) | =VLOOKUP(C1,Sheet1!A1:C4,????,FALSE) | =VLOOKUP(D1,Sheet1!A1:C4,????,FALSE) |
The question marks are what I don't know what to include. Or may be this is the wrong approach

Assuming we are the 13-Oct-22 today, The results of "Sheet 2" am looking for is hereunder. The idea is to get a planning on sheet2 (from sheet1) as from Today the 13-Oct-22. However VLOOKUP may find more than 1 matched data, then it should have other results on other rows.
"Sheet2":
13-Oct-22 | 14-Oct-22 | 15-Oct-22 | 16-Oct-22 |
Microsoft - 2 hours (10h00-12h00) | IBM - 4 hours (09h00-13h00) | ||
Dell - 3 hours (13h00-16h00) |
Thanks for any hint !
