• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cell Adress through text (solved)

arifanmol

Member
can we search cell address from the text or part of text it contains
see the attachment plz
 

Attachments

  • Cell Adress.xlsx
    7.3 KB · Views: 2
Why do you need to get a cell address ? There are many ways to reference a cell wothout having to use its address, avoiding making formulas unnecessarily complicated
 
i want go go that cell directly in a big data sheet then from there i want to direct a range for excel formula s

is it possible
 
i will find out cell address
then suppose it is A15
then i wlll write =sum(A15:A30)
as i dont know what is the cell address where text 'Total' is written
 
By using an INDEX/MATCH combination, the cell is referenced without having to go through the ADDRESS function.
See attached for a simple example
It looks like this =SUM(INDEX($B$1:$B$6,MATCH($A4,$A$1:$A$6,0)):$B$6)
 

Attachments

  • Cell Adress(1).xlsx
    10.1 KB · Views: 1
Back
Top