Problem using Lookup inside Sumifs

Hello,

The following example shows a simple worksheet and a Sumifs formula used to calculate the total net price based on 2 conditions...

Example1.png

However I don't want to have to bring in the Size column as this data is already in another sheet. What I would like to do is something like the following where the size is looked up from another range...

Example2.png

However the Lookup within the Sumifs doesn't work. I thought it would as it acts on its own like a range. Any help would be appreciated, thanks.

please attach a sample excel file

I do not think it possible to do what you are trying to do because the ranges within SUMIFS all need to be the same size

So the solution is to add an additional column to the table, with a looked up value for size on each row - and then all your ranges are the same size

If you do not want the column visible, hide it.
It's a simple lookup formula - why the reluctance to add the column?

As there appears to only one size per vendor then having size serves no purpose in the SUMIF

@JohnTopley - (I was also headed that way but) that would not be the case if there is more than one vendor with same size

@ap1980 - your workbook is not attached to post#3
to attach click on REPLY, then GO ADVANCED, then MANAGE ATTACHMENTS
ManageAttachments.jpg