Results 1 to 5 of 5

Thread: Find text and return cellreference in a chart

  1. #1

    Find text and return cellreference in a chart



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want to find cellreference for ex. 12B (text) in my example. How shall I do that. I want a formula that returns F17 in this case, alternative to return rows and columns.
    As notice this chart has no titles in either axis.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Chart.JPG 
Views:	10 
Size:	32.5 KB 
ID:	2184  

  2. #2
    What is the logic that says 12B should return F17?

  3. #3
    In my chart It is column F and row 17, It can be any valye depending from where chart starts and where value is. I want to look for any text value within this area, and to return cellreference or row/columns

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,479
    Articles
    0
    Excel Version
    365
    check out Domenic's or Valko's suggestions here: http://www.pcreview.co.uk/forums/mat...-t3238035.html

  5. #5
    A chart is a layer above the worksheet, so a value that you see in the chart only relates to a cell by virtue of where the chart is positioned, and the size of the chart. In other words, move the chart or resize it, and that value will be above a different cell.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •