Value from matrix table

Solved/Closed
Vinn1e Posts 1 Registration date Wednesday 2 November 2016 Status Member Last seen 2 November 2016 - 2 Nov 2016 à 21:37
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 2 Nov 2016 à 23:00


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
Related:

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
2 Nov 2016 à 23:00
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