Forum Discussion
Data Extract from 1 Table to another
Hi All
Happy New Year
I have table 1, contains the data of meals when it starts and ends.
I want to find the numbers of meals in Table 2 on each date based on Table 1 as per below image by using any formula or VBA
Could any one can help on this issue in Excel
2 Replies
=INDEX($B$6:$D$8,MATCH(B2,$A$6:$A$8,0),MATCH(C2,$B$5:$D$5,0))
Maybe like this.
