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

[smetu]

Is there a way to find a formula in the green box based on the grey and yellow boxes.
The fact that the transaction ID's of Fund I and Fund II are not in the same columns prevents me to find a solution to this problem.....
It's been a head scratching for me for weeeeks!

 

[smetu]

View attachment 88626

I have opened a new workbook and gives me this.

 

[smetu]

so you'd need to put it somewhere that has a lot of room. it cant show everything that the formula is asking it to return due to other values in the way

Done.

 

[Fluff]

As this is now a duplicate of your other thread, this is locked.