Wednesday, June 1, 2011

yogi_Search An Array And Return Addresses Of All Cells Matching Certain Criteria

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
Forum Joe said:
How do I search an array and return addresses of all cells matching certain criteria?
If I have an array that looks like
Apples Bananas
Bananas Oranges
Oranges Apples
Bananas Oranges
Oranges Bananas
Apples Oranges
I want a function that will return the address of cells that match a criterion.
eg: FunctionName("Apples", A1:B6) will return "A1, A6, B3"
Is this possible?
-----------------------------------------------------------------------