Aug 15 2020 10:58 PM
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'.
Aug 15 2020 11:19 PM
Aug 16 2020 01:59 AM
@Riny_van_Eekelen Thanks a lot. It works.
Aug 16 2020 11:43 AM
@rajenbala You're welcome!