+ Reply to Thread
Results 1 to 4 of 4

Return a reference of the cell

  1. #1
    Registered User
    Join Date
    05-12-2020
    Location
    Brazil
    MS-Off Ver
    2013
    Posts
    13

    Return a reference of the cell

    Hi Guys,

    Does anyone know, how to find value and return the reference of cell.
    Please see attached file.
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,875

    Re: Return a reference of the cell

    Try,

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    08-15-2020
    Location
    malaysia
    MS-Off Ver
    office2007
    Posts
    615

    Re: Return a reference of the cell

    B7 cell formula

    HTML Code: 
    =ADDRESS(2,MATCH(B6,B2:K2,)+1,4)

  4. #4
    Registered User
    Join Date
    05-12-2020
    Location
    Brazil
    MS-Off Ver
    2013
    Posts
    13

    Re: Return a reference of the cell

    It worked!!! Thanks a lot

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return cell reference instead of value
    By lmason in forum Excel General
    Replies: 3
    Last Post: 03-30-2021, 07:37 PM
  2. Looking up a value to return the cell reference
    By Peter397 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-04-2017, 05:04 AM
  3. [SOLVED] Return cell reference
    By Bas1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-29-2016, 07:44 AM
  4. Search a cell reference and return another cell reference
    By klixcel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-05-2016, 04:11 PM
  5. [SOLVED] Return Cell Reference
    By Mike_e in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-17-2011, 06:28 AM
  6. Return of cell reference
    By Saturn in forum Excel General
    Replies: 5
    Last Post: 06-13-2010, 03:44 AM
  7. Return value in cell above the reference
    By Jean in forum Excel General
    Replies: 4
    Last Post: 05-31-2006, 02:50 PM

Tags for this Thread

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