spot_img

How To Create Many To Many Lookup In Excel

This tutorial article is about how to create a many-to-many lookup in Excel. It is something that begins with this data:

 

data tableLayout what you are looking for, in this case I am looking for Timothy Garnish (1), who is also TG (2).looking value

Click on an empty cell (1), and type in this following formula =SUMPRODUCT((B4:B9=B11)*(A4:A9=B12)*(C4:C9)) (2).

sumproduct formula

In conclusion, we just looked up the sum of all books that Timothy Garnish has written for the Thimpson Publishing House, as it is showing above.

Template

You can download the Template here – Download
spot_img
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial