Finding rownumber from 2 dimension lookup

[Frits_Piepie]

Hi, I'm struggeling with a problem in Excel of which I'm not actually sure if it's possible at all. I'm trying to return the first value of a matrix by searching a value.

2 x 2,6 GHz <tbody> </tbody>	990	529	431
4 x 2,6 GHz <tbody> </tbody>	523	145	312
6 x 2,6 GHz <tbody> </tbody>	783	437	402
8 x 2,6 GHz <tbody> </tbody>	427	113	764

<tbody>
</tbody>

Basicly, I want to find the corresponding X x 2,6 Ghz for a value on the same row.

So 437 returns 6 x 2,6 Ghz,
And 431 returns 2 x 2,6 Ghz..

I've tried stuff like lookup, match, vlookup, index but I can't find a way.
Does anyone have a clue if this is possible at all, and if so, how?

Thanks a lot in advance!

 

[FormR]

Welcome to the Forum!

Something like this maybe:

Excel Workbook
	A	B	C	D	E	F	G
1	2 x 2,6 GHz	990	529	431		437	6 x 2,6 GHz
2	4 x 2,6 GHz	523	145	312		431	2 x 2,6 GHz
3	6 x 2,6 GHz	783	437	402
4	8 x 2,6 GHz	427	113	764
Sheet1

 

[vds1]

One more way using table shown by FormR

In G1,

=INDEX($A$1:$A$4,SUMPRODUCT((--($B$1:$D$4=F1)/OR(--($B$1:$D$4=F1))) * ROW($B$1:$D$4)))

 

[pgc01]

I'm trying to return the first value of a matrix by searching a value.

Hi
Welcome to the board

Remark:
When you say "the first value" you mean that the same value may appear in multiple cells?

 

[Frits_Piepie]

Thanks a lot FormR! This really helped.