Feb 10 2021 04:08 AM
I need some formula to implement this. I tried VLOOKUP & LOOKUP but could not get it right
Any help would be appreciated.
Feb 10 2021 04:24 AM - edited Feb 10 2021 04:24 AM
For example:
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.
Feb 10 2021 04:36 AM
@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.