Frits_Piepie
New Member
- Joined
- Oct 24, 2014
- Messages
- 3
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.
<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!
<tbody> </tbody> | 990 | 529 | 431 | |
<tbody> </tbody> | 523 | 145 | 312 | |
<tbody> </tbody> | 783 | 437 | 402 | |
<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!