Home

Lookup a data with several criterias

dodymb
New Contributor

I have a set of data like this.

2.png

 

And I need to make a report in the form like this

1.png

 

I have tried some formulas like Index-Match, VLookup, IF, etc, but none of these worked for me as you can see they only return TRUE of FALSE, not a date as expected.
Can anybody tell me what is the formula to do this?

2 Replies
Your report looks a lot like a pivot table, have you tried using that?

@Jan Karel Pieterse,

Thank you for your response.

Yes if it is a new document. Unfortunately, I have to fill in an existing document.

The data I show in my exampes are only part of a bigger document to illustrate what I want/need to do.

The document is month to month record for multi-year transaction.

I know it is a bad practice, and I have plan to reorganized the document. But as I am newly involved in this task, I have to complete this document first.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies