LOOKUP with two criteria.

Hi,

I have an issue and I am trying to find an elegant way to achieve something. I hope someone could advice me here.

So basically I have this sort of Excel sheet, which I would like to populate from another Excel sheet.

Values X Y Z
1
2
3


So the above table I'd like to fill in from another sheet. I have the control of that other sheet, so I can also rearrange the data if that is any help.
Right now, just so that I can explain what I want to achieve here, I have put the data in that other sheet to look like this:

Value Col Content
1 X something 1
2 X something 2
3 X something 3
1 Y something 4
2 Y something 5
3 Y something 6
1 Z something 7
2 Z something 8
3 Z something 9


So based on this, I would like to populate the first table like this:

Values X Y Z
1 something 1 something 4 something 7
2 something 2 something 5 something 8
3 something 3 something 6 something 9

So basically, I would like to look from table in another sheet a value based on Value and Col matches.

What would be the easiest way to achieve this? Some lookup function perhaps? And would it make things easier to format the data on another sheet?

Thanks in advance.

Br,
Mika