Help with lookup values - multiple criteria

markdoc5

New Member
Joined
Jan 27, 2021
Messages
14
Office Version
  1. 365
Platform
  1. Windows
Hey All - stuck on this for a few hours and pulling my hair out

I have 2 sheets (thats the way data comes to me)

Book1
ABCD
1DateUsername CampaignSales
213/07/2023john smithtest1?
314/07/2023john smithtest2?
415/07/2023john smithtest3?
Sheet1


Book1
ABCDE
1DateUsername test1test2test3
2########john smith121
3########john smith010
4########john smith153
Sheet2


Basically on the first sheet I want it to pull how many sales username has had if it matches date/username/campaign which is on the headers on sheet 2 rather on rows like sheet1 ( hence the headache) -hopefully that makes somewhat sense .. staring at screens all day!
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
How about
Excel Formula:
=SUMPRODUCT((Sheet2!$A$2:$A$4=A2)*(Sheet2!$B$2:$B$4=B2)*(Sheet2!$C$1:$E$1=C2)*(Sheet2!$C$2:$E$4))
 
Upvote 1
Solution
Glad to help & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,620
Latest member
dsubash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top