Lookup to map data

Copper Contributor

I need some formula to implement this. I tried VLOOKUP & LOOKUP but could not get it right

Any help would be appreciated.

 

codecrazy_0-1612958790378.png

 

2 Replies

@codecrazy 

For example:

S0109.png

The formula in E2 is

 

=INDEX($C$1:$C$4,MATCH(1,INDEX(($A$1:$A$4=F$1)*($B$1:$B$4=$E2),,),0))

 

This can be filled down and to the right.

@codecrazy As a variant and since you tagged your question with "Excel for web". Then you can use FILTER or why not create a pivot table. Both options are demonstrated in the attached workbook.