Forum Discussion
Solved
INDEX MATCH MATCH #N/A Error
HELP! In a table of data, I need to match 3 variables and select the corresponding value. Between the 3 variables, there should only be one match. For the life of me, I can't sort this out :( ...
Got it!
=INDEX($C$3:$F$8,MATCH(1,(A13=$A$3:$A$8)*(B13=$B$3:$B$8),0),MATCH(C13,$C$2:$F$2,0))
Screenshot attached.
Got it!
=INDEX($C$3:$F$8,MATCH(1,(A13=$A$3:$A$8)*(B13=$B$3:$B$8),0),MATCH(C13,$C$2:$F$2,0))
Screenshot attached.