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

[Chip]

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.

 

[Tom Ogilvy]

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

 

[Chip]

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]

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