You're probably looking for INDIRECT instead, if you want to display the value of the content of A3 in this example. So =INDIRECT("A"&D3) which is the same as =INDIRECT(CONCATENATE("A",D3))