Value from matrix table [Solved/Closed]

Vinn1e 1 Posts Wednesday November 2, 2016Registration date November 2, 2016 Last seen - Nov 2, 2016 at 09:37 PM - Latest reply: Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen
- Nov 2, 2016 at 11:00 PM


Trying to get rate in G14 that comes from the matrix
E14 is a list of A3:A10
F14 is a list of B2:J2
See more 

1 reply

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Nov 2, 2016 at 11:00 PM
0
Helpful
Vinn1e, Good evening.

Try to use:

=INDEX(C3:J10, MATCH(E14, A3:A10, 0), MATCH(F14, C2:J2,0))

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão