LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Giantrobot
 
Posts: n/a
Default Lookup table for two conditions

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sum cells in table using column and row conditions [email protected] Excel Worksheet Functions 2 June 6th 06 08:02 AM
look up table values with multiple conditions TechMGR Excel Discussion (Misc queries) 3 January 10th 06 12:52 AM
lookup? list data into summary table Joe Excel Worksheet Functions 6 December 22nd 05 12:25 AM
pivot table sort entries that don't yet appear in table rachael Excel Discussion (Misc queries) 11 September 19th 05 11:29 PM
Pivot table doing a lookup without using the lookup function? NGASGELI Excel Discussion (Misc queries) 0 August 2nd 05 05:08 AM


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"