+ Reply to Thread
Results 1 to 4 of 4

Return cell reference instead of value

  1. #1
    Registered User
    Join Date
    03-29-2021
    Location
    USA
    MS-Off Ver
    Professional Plus 2019
    Posts
    3

    Return cell reference instead of value

    Good afternoon,

    I want to use a lookup-type function to look in cell A2 (Sheet 1) for instance, and find cells that match in column A (Sheet 2); then, return the CELL REFERENCE (for example, A2:A6), instead of the value. Does anyone know if this can be done?
    Sheet 2 column A is sorted alphabetically.

    EXAMPLE.
    Sheet 1
    Column A Column B
    Row 1 Monday A2:A6

    (Cell B1 contains the formula resulting in a cell reference "A2:A6", rather than the value "Monday")

    Sheet 2

    Column A
    Row 1 Sunday
    Row 2 Monday
    Row 3 Monday
    Row 4 Monday
    Row 5 Monday
    Row 6 Monday
    Row 7 Tuesday
    Row 8 Tuesday
    Row 9 Wednesday
    Row 10 Thursday
    Row 11 Thursday

    Thanks.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Return cell reference instead of value

    Try this:

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


    It worked in my test sheet. These don't have to be sorted in order but all the values for a given day have to be together.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    03-29-2021
    Location
    USA
    MS-Off Ver
    Professional Plus 2019
    Posts
    3

    Re: Return cell reference instead of value

    Thank you for your help with this. It worked great! Much appreciated.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Return cell reference instead of value

    Glad to help, and thanks for the rep!

+ 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. [SOLVED] Return Yes or No based on reference cell value but return blank if reference cell blank
    By manythanks_1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2021, 09:27 AM
  3. 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
  4. [SOLVED] Return cell reference
    By Bas1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-29-2016, 07:44 AM
  5. 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
  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

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