Sunday, May 12, 2013

yogi_Compute Cell Address Of A Specified Entry In A Specified Range With Single Instance


                                          Google Spreadsheet   Post  #1192
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 12, 2013
user Fabio Magalhaes (https://productforums.google.com/forum/#!mydiscussions/docs/tdvJ7kDVTFA)

Hello Hyde and Yogi. Thank you two for the answer. Unfortunatelly, I still cound'nt solve my issue.

Following yourt advices, specially from Yogi (because I don't understand very well the query function Hyde suggested) I get a circular dependency.

The problem is that I really have a circular operation there, and now I do not know how to get around it. The dependency appear because I select the value from a validation, then later I'm trying to find their position.

Here is the link to the original spreadsheet:
https://docs.google.com/spreadsheet/ccc?key=0Ahyt5wmsuvREdEdwcmstVWdjSmdKVGVCMnhDSnI3VkE&usp=sharing
I hid the useless sheets for this issue.
I'm trying to find the address of Perícias!H3 in the interval Lista!F2:AA39. I can find the row with the formula match, but the column search return the circular dependency.

Greeting :)

-----------------------------------------------------------------------------------------------------------------------
let us have a look at the following