Thread: Retrieving data based on more than 1 criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TP TP is offline
external usenet poster
  
Posts: 8
Default Retrieving data based on more than 1 criteria
Have the following data set and need to find say, the retrieve the number for
say, VIC 2007, is there an easy formula method? thanks, tony

VIC QLD NSW
2007 10 20 30
2008 5 12 15
2009 50 40 30

Reply With QuoteReply With Quote