How must i do this ... search for and than find ...

[arcootje]

Table:


Name Pietersen Jansen Klaasen
Jan 10 20 30
Piet 11 12 13
Klaas 50 51 53

I want to search for (example ) Jansen and than for Piet.
The result must be 12

Can this be done in a formula?

 

[Andrew Poulsom]

Like this:

=INDEX(A1:D4,MATCH("Piet",A1:A4,0),MATCH("Jansen",A1:D1,0))

"Piet" and "Jansen" can be cell references.

 

[Peter_SSs]

arcootje

Try this. Formula in H3: =INDEX(A1:D4,MATCH(H2,A1:A4,0),MATCH(H1,A1:D1,0))

Mr Excel.xls
	A	B	C	D	E	F	G	H	I
1	Name	Pietersen	Jansen	Klaasen			Row 1	Jansen
2	Jan	10	20	30			Column A	Piet
3	Piet	11	12	13			Result	12
4	Klaas	50	51	53
5
Sheet4