CELL and CONCATENATE Function usage - Formula Error

Copper Contributor

Can anyone tell what is the problem with this formula?

 

=CELL("address",CONCATENATE("E",(MATCH(A44,A2:A60,0))))

 

I am trying to retrieve a value of a cell whose column is 'E'. 

3 Replies

@rajenbala Try this way:

=CELL("address",INDIRECT(CONCATENATE("E",(MATCH(A44,A2:A60,0)))))

 

@Riny_van_Eekelen Thanks a lot. It works.