Forum Discussion
Sameer_Kuppanath_Sultan
Jan 11, 2022Brass Contributor
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 ...
OliverScheurich
Jan 11, 2022Gold Contributor
=INDEX($B$6:$D$8,MATCH(B2,$A$6:$A$8,0),MATCH(C2,$B$5:$D$5,0))
Maybe like this.
Sameer_Kuppanath_Sultan
Jan 12, 2022Brass Contributor