refer to cell using the value in Row 1 and column A
 

I need to locate a cell that is the intersection of cells in row 1 and column
A by matching text . For example find "Allowed" in Row 1 and "WaterTemp" in
Column A and give me the cell address at the intersection. I tried nesting
two match functions inside index function but it hiccupped.

refer to cell using the value in Row 1 and column A
 

=index(A1:Z26,Match("WaterTemp",A1:A26,0),Match("A llowed",A1:Z1,0))

--
Regards,
Tom Ogilvy


"Chip" wrote in message
...
I need to locate a cell that is the intersection of cells in row 1 and
column
A by matching text . For example find "Allowed" in Row 1 and "WaterTemp"
in
Column A and give me the cell address at the intersection. I tried nesting
two match functions inside index function but it hiccupped.

refer to cell using the value in Row 1 and column A
 

Tom,
Thanks for the quick response
Your response is what I tried in VBA but I get "Can't set index
property..."error. I am grabbing a value from Access and need to insert it
into the desired cell. I did use a clunky routine to find the text and grab
the column from row 1 and the row from column A to construct an address. It
works but seems inefficient.


"Tom Ogilvy" wrote:

=index(A1:Z26,Match("WaterTemp",A1:A26,0),Match("A llowed",A1:Z1,0))

--
Regards,
Tom Ogilvy


"Chip" wrote in message
...
I need to locate a cell that is the intersection of cells in row 1 and
column
A by matching text . For example find "Allowed" in Row 1 and "WaterTemp"
in
Column A and give me the cell address at the intersection. I tried nesting
two match functions inside index function but it hiccupped.

refer to cell using the value in Row 1 and column A
 

set rw = Range("A1:A26).Find("WaterTemp")
set col = Range("A1:Z1).Find("Allowed")
cells(rw.row,col.col).Value = "Whatever"

--
Regards,
Tom Ogilvy


"Chip" wrote in message
...
Tom,
Thanks for the quick response
Your response is what I tried in VBA but I get "Can't set index
property..."error. I am grabbing a value from Access and need to insert it
into the desired cell. I did use a clunky routine to find the text and
grab
the column from row 1 and the row from column A to construct an address.
It
works but seems inefficient.


"Tom Ogilvy" wrote:

=index(A1:Z26,Match("WaterTemp",A1:A26,0),Match("A llowed",A1:Z1,0))

--
Regards,
Tom Ogilvy


"Chip" wrote in message
...
I need to locate a cell that is the intersection of cells in row 1 and
column
A by matching text . For example find "Allowed" in Row 1 and
"WaterTemp"
in
Column A and give me the cell address at the intersection. I tried
nesting
two match functions inside index function but it hiccupped.