Help with Lookup in conjuction with concatenate

[nami]

Hello Excel experts,

I am trying to use the vlookup function to populate the cell highlighted yellow.
Please see attached example. Refer to sheet sour,ce I need the 25th percentile for Labor Expense for Master Facility.

I was trying to concatenate Ultrasound+Labor Expense+Master facility to lookup from the Source table.

Is that even possible?

Thank you,
Nami

[darkyam]

Try =SUMPRODUCT(--(Source!$B$2:$B$13=B2)*--(Source!$E$2:$E$13=C2)*--(Source!$F$2:$F$13="Master Facility TVRH"),Source!$H$2:$H$13)

[martindwilson]

whats with the spare * ? darkyam
=SUMPRODUCT(--(Source!$B$2:$B$13=B2),--(Source!$E$2:$E$13=C2),--(Source!$F$2:$F$13="Master Facility TVRH"),Source!$H$2:$H$13)
or
=SUMPRODUCT((Source!$B$2:$B$13=B2)*(Source!$E$2:$E$13=C2)*(Source!$F$2:$F$13="Master Facility TVRH"),Source!$H$2:$H$13)
surely?

[darkyam]

Spare *? You do realize your second formula has the same number of them, right? The "spare" could refer to --, but is that really worth calling me out when the formula already works and yours isn't significantly shorter?

[martindwilson]

no im asking why * and -- it looks unnecessary thats all

[darkyam]

Sorry. I put the * instead of , in there because that's how I first saw the mods here doing it with conditions in a sumproduct formula, leaving the portion after the , to be the array added up or, in this case, looked up. My understanding was that when you have conditions that don't evaluate to numbers, you have to put -- before each condition to force it to evaluate to 1 or 0.

[nami]

Thanks for your responses.
I am a little confused do I need to put a "*" or a "," between the Fx arguments?

Thanks
Nami

[ChemistB]

Either will work in this case.