Hey there! I was wondering, if you guys could help me with the specific task.
Case: I have Broker IDs in the rows, and transaction dates from April to June (every single day) in columns. On the other sheet, I have office IDs (offices where those brokers delivered transactions) and payment dates (from April to June, every single day as well). I want to write a formula that says, for the specific Broker ID (in rows) and Transaction date (in columns), deliver me the office ID, based on the payments that have occurred during this time period.
Basically, I want to know, in which office did the broker made transaction and on what date.
Please be kind to help me with this. Thank you in advance!
Bookmarks