Assuming your data in A1:C4

your criterias
In E2: holds "A"
In E3: holds "B"
In F1: holds "x"
In G1: holds "y"

=INDEX($B$1:$B$4,MATCH(1,($A$1:$A$4=$E2)*($C$1:$C$ 4=F$1)))

ctrl+shift+enter, not just enter



"manyquestions" wrote:

Hi

I want to do the following:

make

A 2 x
A 2 y
B 2 x
B 2 y

into

x y
A 2 2
B 2 2

How do I do it ?