Microsoft Office Forums - View Single Post - [Solved] VLookup or Index Multiple Tables

Thread: [Solved] VLookup or Index Multiple Tables

View Single Post

Old

07-27-2018, 06:23 AM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

Try this formula in P16, copied down and across.

=SUMPRODUCT(($D$12:$J$40=P$15)*($C13:$C41=$N16),$D 13:$J41)

Reply With Quote