Cell reference from a looked up value

[JohnJack]

Hi,

I'm trying to get the cell reference of a value looked up in a table.
For example:

A table of values are found in A4 to J13 (10x10 table). A4=1,
B4=2,A5=11, B5=12 and so on (ie 1 to 10 is in the first row, 11 to 20
is in the 2nd row, Last row is 91 to 100 (found in A13:J13).

A1 contains the value I want found
B1 contains some formula that gives me the location in the table
(absolute).

i.e., if 1 is in cell A1, I want B1 to have "A4"
if 100 is in cell A1, I want B1 to Have "J13"

Is there a function or combination of functions that would allow me to
do this?

Thanks for any help you can provide.

Jack

 

[Bob Phillips]

=ADDRESS(ROW($A$4)+MOD($A$1,10)-1,COLUMN($A$4)+INT($A$1/10))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[JohnJack]

Thanks.

I was hoping there was an easier way to do that, but I guess not.