Hi!

I'm having some difficulties with finding the right formula (probably a
combination of several functions) as I would like to obtain a formula, which
will not only vlookup according to one lookup value (in this case a row
label) but also according to specific column label.
The thing is that I'm looking for some standar formula, which will enable me
to return the correct data, as worksheets differ from time to time - some
have different rows (Peter, Steve, Olga/ the other time Olga, Kate Betty).
The same happens with columns (one time it starts with X, the other time it
starts with Z and does not include P).

Would anyone be able to help me?

I would be glab, as I really can not solve it myself :(

X Y Z P O
Peter
Caroline 3
Steve
Olga
Kate 4
Betty


Z O Y
Caroline 3 8 5
Kate 4 6 0
Betty 7 2 1