Maybe...

=INDIRECT("'sheet1'!r"&MATCH(A11,'Sheet1'!$A$2:$A$ 1031,0)+1&"C18",FALSE)

This is basically:

=INDIRECT("'sheet1'!r711C18",FALSE)

Row 711, column 18)





wrote:

2003

Need syntax (worksheet formula)

Contents of 'Sheet1'R711 = "XXX"

Obtained address of R711 via

MATCH(A11,'Sheet1'!$A$2:$A$1031,0)+1 which returned 711

I know the column is "R" so I used COLUMNS(R1) to force 18 so Column is 18 or "R"

On Sheet2 in Cell D1, I want the value "XXX" to appear which is the value in 'Sheet1'R711

How do I write the formula in Sheet2 in Cell D1 using the formulas MATCH and COLUMNS?

TIA EagleOne

--

Dave Peterson