Vlookup with multiple criteria (Sample workbook attached)

**swade730** · 04-26-2015, 12:56 PM

Hi,

I am needing to create a vlookup or what may seem to be a sum if formula to solve the problems in the attached workbook.

Details are inside.

**Jacc** · 04-26-2015, 01:16 PM

I'm a bit uncertain about this. You had few sampels and did not fill in the expected results. Anyway try this in I3:

Formula:

Please Login or Register  to view this content.

**sandy666** · 04-26-2015, 01:20 PM

try
=SUMIFS(C2:C6,A2:A6,H3,B2:B6,J2)
where H2 = John and J2 = lube

I'm late

Re: Vlookup with multiple criteria (Sample workbook attached)