Transpose diagonally

[emy1]

9.ods (33.4 KB)
I have this situation. How can i get the values from sheet2 transposed diagonally on sheet 1, when the row date is equal to column date?
I need a function (not array), so that when the source updates, the result updates.
Thank you.

[PKG]

8978 1.ods (10,5 KB)

[schiavinatto]

In B3

=IFERROR(VLOOKUP(IF($A3=B$1;$A3;"");$Sheet2.$A:$B;2;0);"")

and replicate to the other cells.

[emy1]

It works, but in this situation how can i do it?
10.ods (41.0 KB)
There’s an extra condition.
Sorry for not putting the issue from the beginning.

[schiavinatto]

@emy1

It works, but in this situation how can i do it?

What is the expected outcome?

---

Guess

In C3

=IFERROR(VLOOKUP(IF($B3=C$1;$B3;"");$Sheet2.$A:$D;IF($A3="Alfa";2;IF($A3="Beta";3;IF($A3="Gamma";4;"")));0);"")

and replicate to the other cells.

[PKG]

The second “if” statement could be replaced.