Dynamic sub-table with multiple search criteria

[URSUS]

Hi Guys,

I have been trying to develop some of the tricks from ”Excel is Fun” Youtube Channel but I seem to get nowhere: The sheet I am working with is “Series(1) an” and the database is found in “538 an”. In cell “'Series(1) an'!E1” I have modified the formula to filter both criteria en parallel successfully. However, when making the same changes in the formula in cell “'Series(1) an'!A9” I seem to obtain the wrong outcome. I have audited the formula upside down and have even checked the entire formula with the F9 key when editing on the formula bar; I obtain the correct value but when I press enter to introduce the formula the result is still wrong.

An someone help, I have trying for quite a lot of time but continue stuck on this issue.

You will find the file on the following link:

https://docs.google.com/leaf?id=0B4wedgxjRfrEMjEzNWFjOTgtMDRlYi00YzA0LTk3Y2UtOWQ0ZjM5YTk2YmFi&hl=es


Many thanks,


URSUS

 

[Robert Mika]

Hi ursus and welcome to the board.
This is array formula you need to confirm it with CTRL+SHIFT+ENTER

 

[URSUS]

Dear Robert,

It works wonderfully. It is sometimes fustrating to see how a very small little step can kill all the hard work.

Many thanks for your response.

You have saved the day.

Rgds,


URSUS

 

[URSUS]

Many thanks, it worked wonderfully.

You are a star

It just makes me feel silly that I didn't notice such a basic thing it myself

Regads,


URSUS