Forum Discussion
Solved
Look up multiple matching values
I am trying to find a formula for highlighted cells H2 and H3. My desired result is on "Final Result" table. Table 1 and Table 2 are on separate sheets. Thanks.
Comfortable in vlookup and Index match please follow simple formula,
=IF(VLOOKUP($A$2,$A$2:$B$5,2,0)=D2,INDEX(E2:E5,MATCH($B$2,$D$2:$D$5,0)))
=IF(VLOOKUP($A$2,$A$2:$B$5,2,0)=D2,INDEX(E2:E5,MATCH($B$2,$D$2:$D$5,0)))
That only worked because you forgot to fix the part E2:E5. Otherwise, "Part X" also comes out in line 3, because x and y have the same entry in the final report.
That is the reason why I used filter().