G
Giantrobot
I want to set up a lookup command based on two criteria. I'm not sure which
step to take. The table has a column range of A:M and a row range of
6:711... My Table is set up as so:
SAZ Housing 2006/07 2007/08 2008/09
1110823 SFD 100 250 500
1110823 MFA 25 50 90
1130401 SFD 0 0 60
1130401 MFA 50 75 0
1130402 SFD 5 10 15
1130402 MFA 25 20 15
What I am trying to do is set up a lookup command to lookup the SAZ and
Housing (i.e. looking up 1110823 and SFD would return 100 for year 2006/07,
or 1130402 and MFA would return 15 for 2008/09, etc...). What steps should I
take?
step to take. The table has a column range of A:M and a row range of
6:711... My Table is set up as so:
SAZ Housing 2006/07 2007/08 2008/09
1110823 SFD 100 250 500
1110823 MFA 25 50 90
1130401 SFD 0 0 60
1130401 MFA 50 75 0
1130402 SFD 5 10 15
1130402 MFA 25 20 15
What I am trying to do is set up a lookup command to lookup the SAZ and
Housing (i.e. looking up 1110823 and SFD would return 100 for year 2006/07,
or 1130402 and MFA would return 15 for 2008/09, etc...). What steps should I
take?