How to return the date of a transaction based on the Transaction ID (and Transac IDs are several columns!)

[smetu]

Without moving anything in the table (but you can add a row above if it helps), and based on the Transaction ID's (that you see are in several columns), I have to find a formula that will return the dates of each transaction.
In my real file, I have a table of thousands of rows.
If anyone can help with this head-scratcher problem!

 

[Fluff]

Duplicate to: How to find a value based on 2 criteria: one horizontal and one vertical BUT which is not always in the same column.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.