Hello All,
I am using Excel 2013 and have a problem as shown in the attached sample data.
I have two sheets viz output and 10.02.2022 (this will change on daily basis).
In output sheet I need to pull up value from Cell S139 from the 10.02.2022 sheet as follows:
If Col A (Category) matches Cell A137 on 10.02.2022 sheet.
If Col B (Item) matches Cell B139 on 10.02.2022 sheet.
If Col C (Type) matches Cell H139 on 10.02.2022 sheet.
Then it should pull up the value from respective rows of Cell S139 till down of 10.02.2022 sheet.
As this will be part of daily progress report if the formula can take into consideration the cell M1 of Output sheet and Cell U3 of 10.02.2022 for updating.
I have colored for explanation purpose only.
Thanks in advance.
Bookmarks