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

By far the simplest method is to apply a filter using Data - Filter and then
filter on London, Jan and 3 in the appropriate columns.

"nir020" wrote:

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

=INDEX(D1:D6000,MATCH(1,(A1:A6000="London")*(B1:B6 000="Jan")*(C1:C6000=3),0)
)

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"nir020" wrote in message
...
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