Forum Discussion
rajenbala
Aug 16, 2020Copper Contributor
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'.
3 Replies
- Riny_van_EekelenPlatinum Contributor
- rajenbalaCopper Contributor
Riny_van_Eekelen Thanks a lot. It works.
- Riny_van_EekelenPlatinum Contributor
rajenbala You're welcome!