Finding a value with horizontal and vertical parameters

willian2142

New member
Joined
Aug 28, 2017
Messages
1
Reaction score
0
Points
0
Hi everyone,

I need to find a value on line 2, then it needs to find the value on the vertical column, and finally the option correspondent to that value.
In the image bellow it's an exemple of what i need.

fge2O
aWl3luF.jpg
 
Try:

=INDEX(A3:A6,MATCH(C10,INDEX(B3:G6,0,MATCH(C9,B4:G4,0))
 
Back
Top