Problem with indirect function

Hi guys,

I have been trying to make this function using indirect work:

Please Login or Register  to view this content.

It gives the following result (that works if i use it as formula alone):

Please Login or Register  to view this content.

But when using indirect it simply says the "#REF!" error.

Any clue?

Thank you,

Jose

correct, I changed the function to use various indirects (one for each cells I want to retrieve)

Now it gives me a #VALUE! error..

Please Login or Register  to view this content.

Any clue?

Found a solution! the column function was retrieving an array, that's why was not working, I put the MIN(COLUMN()) and works fine

Please Login or Register  to view this content.

Thank you for the help!