Thread: Returning data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nir020 nir020 is offline
external usenet poster
 
Posts: 31
Default Returning data

I have a data table with four columns in Excel,it looks like this.

Area Month Qu_No Qu_Ans
London Jan 1 3
London Jan 2 4

etc

There are over 6000 records in this table.
Is it possible to create a function that will select from this table the
data from the Qu_Ans column where the data in the area column = London, the
data in the month column=Jan and the data in the Qu_No column = 3

Thanks in advance