Mashtonsmith
Board Regular
- Joined
- Oct 1, 2004
- Messages
- 164
Ok - so I'll do my best at explaining my problem.
I need a formula that with firstly lookup a member within a table by matching to a reference number.
Once that match has been established, I then need to lookup data from a a year.
So...
The main data table looks like this..
Column 1 Column 2 Column 3 Column 4
Ref YEAR Amount 1 Amount 2
1234 2010 100 150
1234 2011 200 150
1234 2012 123 150
1234 2013 200 200
1234 2014 100 300
1234 2015 150 150
1234 2016 100 100
I want look Lookup Ref = 1234, then lookup 2012 (or any entered year) to return 123 - all in one formula
Someone has suggested Sum Ifs?
Any help appreciated.
I need a formula that with firstly lookup a member within a table by matching to a reference number.
Once that match has been established, I then need to lookup data from a a year.
So...
The main data table looks like this..
Column 1 Column 2 Column 3 Column 4
Ref YEAR Amount 1 Amount 2
1234 2010 100 150
1234 2011 200 150
1234 2012 123 150
1234 2013 200 200
1234 2014 100 300
1234 2015 150 150
1234 2016 100 100
I want look Lookup Ref = 1234, then lookup 2012 (or any entered year) to return 123 - all in one formula
Someone has suggested Sum Ifs?
Any help appreciated.