Value from matrix table [Solved]

Ask a question Vinn1e 1Posts Wednesday November 2, 2016Registration date November 2, 2016 Last seen - Last answered on Nov 2, 2016 11:00PM

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 
moins plus
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
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!