Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sum cells in table using column and row conditions | Excel Worksheet Functions | |||
look up table values with multiple conditions | Excel Discussion (Misc queries) | |||
lookup? list data into summary table | Excel Worksheet Functions | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |