Results 1 to 7 of 7

how to get a cell name in a table

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    portugal
    MS-Off Ver
    2007
    Posts
    16

    how to get a cell name in a table

    Hi all,

    ____A____B____C____D____E____F

    1___%____1____2____3____4____5

    2___3____1,2__1,3___2,1__1,4__2,3

    3___6____2,1__2,3 __3,1__1,3___1,5


    suppose I have a table like above


    If I have a reference cell that tells me that the value I need is 1,4, I know that its name is "4%3" because it is in E1 and in A2. The % parameter in A1 is because I need it between.


    So, is it possible to get that name having a reference cell, lets say it is H1??


    Thanks
    Last edited by biluulib; 02-11-2015 at 05:15 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 11-25-2014, 08:35 PM
  2. Help with VBA code to find bottom row in pivot table and fill table cell borders
    By Eric111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2014, 07:15 PM
  3. LOOKUP TABLE -blank cell in the table array to return a figure
    By jonnops in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-28-2014, 09:08 AM
  4. Replies: 0
    Last Post: 07-02-2013, 11:30 AM
  5. [SOLVED] Paste from Word table so that 1 table cell = 1 Excel cell
    By Dave G in forum Excel General
    Replies: 4
    Last Post: 06-16-2005, 08:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1