Friday, November 11, 2011

Excel 2003 syntax correction or different function for complex reference should be used ?

if you're trying to reference the cell in column A, row 'x1' then the formula should be =indirect("A" & x1)

No comments:

Post a Comment