Find data in Range, Return Cell Reference
That's really useful, Luke. Thanks.
"Luke M" wrote:
This array* formula will also work, returns format of "D4":
=ADDRESS(MAX(IF(B1:D15=A1,ROW(B1:D15))),MAX(IF(B1: D15=A1,COLUMN(B1:D15))),4)
*Confirm formula using Ctrl+shift+Enter
If you want an absolute reference returns ($D$4) remove the 4 from last
arguement of the address function.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Hugh" wrote:
I want to see if a value in A1 is present in an array, say B1:D15, and then
return the refernce of the cell in which the value is held. The value in A1
will not occur more than once in the array.
For instance, if the value in A1=30, and 30 appears in cell D4, I want to
return D4 (or $D$4).
Is there a formula or function that will return the cell reference of cell
containing a specific value?
Thanks in advance.
|