Forum Discussion

Copper Contributor

Aug 16, 2020

CELL and CONCATENATE Function usage - Formula Error

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'.

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Aug 16, 2020

rajenbala Try this way:

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

rajenbala
Copper Contributor
Aug 16, 2020
Riny_van_Eekelen Thanks a lot. It works.
- Riny_van_Eekelen
  Platinum Contributor
  Aug 16, 2020
  rajenbala You're welcome!