Hello everyone.
I would like to pick up automatically a value in a table (matrix) knowing the coordinates of this value in the table.
Example :
a b c
100 1 2 3
200 4 5 6
300 7 8 9
In this example I would like to find the value corresponding to the couple of the coordinates (200 ; b) which in reality is “5” .
Do you have any idea how to ?
Friendly
Sokol
Assuming you table starts in A1
=vlookup(200,a1:d3,3,0)
Check out vlookup in your help file.
i think you need index()
=INDEX($A$1:$D$4,MATCH(F1,$A$1:$A$4,0),MATCH(G1,$A$1:$D$1,0))
see attached
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks