A | B | C | D | |
1 | Product A | |||
2 | Gross Profit | |||
3 | Balance | 1/6/2020 | 30/6/2020 | USD 1,000 |
Dear All,
**I tried search thru the whole forum but very unlikely any formula provided before match my request. Hence i decided to post a new thread.
Objective: The above shows a partial extraction from my big work book, I wish to retrieve the value of USD1,000 in another sheet tab based on the criteria in column A3, B3, C3, and row D1, D2.
Would be very much appreciated if anyone could advise and assist to draft if there is a formula exist for retrieving the value on D3 based on multiple criteria at respective columns and rows.
Thanks and regards,
Fate