Report

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 
Helpful
+0
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!