VLookup

[mulholm]

Is there a way to do V Lookup with multiple parameters.

I will try explain as best as i can below what i'm looking for:

[TABLE="width: 446"]
<tbody>[TR]
[TD]Paid Breaks[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Break Time Available[/TD]
[TD]Break Time Used[/TD]
[/TR]
[TR]
[TD]Agent1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


this is what appears on sheet1

On sheet 2 i have the following data:

[TABLE="width: 488"]
<tbody>[TR]
[TD]Agent[/TD]
[TD]Category[/TD]
[TD]Activity[/TD]
[TD]Duration Mins[/TD]
[TD]Duration (Secs)[/TD]
[TD]Duration%[/TD]
[/TR]
[TR]
[TD]Agent1[/TD]
[TD]ASH[/TD]
[TD]Unpaid Break[/TD]
[TD="align: right"]420[/TD]
[TD="align: right"]25,200[/TD]
[TD="align: right"]9.38%[/TD]
[/TR]
[TR]
[TD]Agent1[/TD]
[TD]OffLine[/TD]
[TD]Paid Break[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]227[/TD]
[TD="align: right"]0.08%[/TD]
[/TR]
</tbody>[/TABLE]

On sheet1 i have used V Look up function to search for "Agent1" and return data from column "5" which is the duration of the code they used and put it in "Break Time Used" column. However i am looking to only retrieve for "Paid Break" only which is where it gets confusing.

Is there a way to use V Look up and ignore "Unpaid Break" and only return "Paid Break"

 

[RasGhul]

Try,

=SUMPRODUCT(($A$2:$A$3=A9)*($C$2:$C$3="Paid Break")*$E$2:$E$3)

 

[Aladin Akyurek]

=SUMIFS(Sheet2!E:E,Sheet2!A:A,$A3,Sheet2!C:C,"paid break")

where A3 = Agent1.

 

[mulholm]

that worked perfectly

 

[Aladin Akyurek]

that worked perfectly

Great, thanks for the update.