Value from matrix table

[Solved/Closed]
Report
Posts
1
Registration date
Wednesday November 2, 2016
Status
Member
Last seen
November 2, 2016
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-


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

1 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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