Formula to find the address of particular value (row & column position unknown)

Greetings,

I have an online PDF file whose contents are exported to an excel worksheet. For any export, the placement of the labels from the PDF file are not always in the same row / column in the excel file.

So, if I am searching for a particular label in the excel file, I know neither its row position or column position. Is there any excel formula that can find the address of particular value in the sheet in such a scenario?

I am currently using a UDF but I noticed that it slows down the workbook.

Any help would be appreciated
Asha

Hi,

This will return the address of the cell whose value is D1 in the named range "table"

=ADDRESS(MAX((table=D1)*ROW(table)),MAX((table=D1) *COLUMN(table)),4)

Note that it's an array function and as such needs to be entered wtih CTRL, SHIFT and ENTER

Be aware that the Array provided is open to erroneous results should the given value appear multiple times (eg A10 and B3)

To account for this and to avoid expensive double evaluation it is better (IMO) to return the "co-ordinates" in one cell and the address in another, eg:

A1: =MIN(IF((table=D1),ROW(table)+COLUMN(table)/1000000))
confirmed with CTRL + SHIFT + ENTER

B1: =ADDRESS(INT(A1),ROUND(MOD(A1,1)*1000000,0))
confirmed with Enter

If Column should take preference over Row (eg A10 rather than B3) then adjust ROW & COLUMN accordingly and account for the switch in the ADDRESS call also.