pulling data from one sheet to another with multiple criterias

newtothis47

New Member
Joined
Oct 13, 2017
Messages
3
hi there,

i feel like this is simple but having trouble figuring it out. i basically want to pull data from one sheet to another where the data has to meet multiple criterias.

the criterias are week#, year, and business unit if all of those criterias match on both sheets i want a return of the number sent which is a different column.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
1. will there only ever be 1 unique match or could there be more than 1?
2. Do you need to return all relative data, or just a value
3. If just a value (or sum of values) take a look at using SUMIFS()
 

newtothis47

New Member
Joined
Oct 13, 2017
Messages
3
1. will there only ever be 1 unique match or could there be more than 1?
2. Do you need to return all relative data, or just a value
3. If just a value (or sum of values) take a look at using SUMIFS()

There should only return a unique value. and it wouldnt be a sum. It is more I am trying to do a data dump in one sheet and have that return that unique in another sheet based on criterias
 

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
OK, even if there is still only 1 matching data piece, you could still use SUMIFS
 

newtothis47

New Member
Joined
Oct 13, 2017
Messages
3
OK, even if there is still only 1 matching data piece, you could still use SUMIFS

Thanks! to make things a little bit more complicated is there a way to have criteria1 in the formula = another column instead of typing it in.
 

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
Hard to make suggestions blindly :( Can you give some sample data and show what you want?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,518
Messages
5,523,352
Members
409,512
Latest member
Exceldoktor

This Week's Hot Topics

Top