Try
=OFFSET(INDIRECT(TRIM(B17)),,1)
you must have a space or something in B17 as well as a43,
if B17 contains a cell address then the above formula will return whatever is the
first cell to the right of that cell address.. The only way it can return a ref error is if it is not a cell reference.
Regards,
Peo Sjoblom