+ Reply to Thread
Results 1 to 3 of 3

Return the Location of Cell

  1. #1
    Registered User
    Join Date
    12-18-2018
    Location
    Phuket, Thailand
    MS-Off Ver
    Windows 10 - MS Office 2016
    Posts
    47

    Return the Location of Cell

    Hi all,

    I would like a forumla (used in Sheet2) that searches the whole of Sheet1 for the word "PRODUCT" (exact match) and return the cell location, preferably with the Sheet1 name too.

    Example: 'Sheet1'!$A$1

    Thanks in advance,

    Danny

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,841

    Re: Return the Location of Cell

    This is for sheet1, A1:AV10000

    Please Login or Register  to view this content.
    **Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

  3. #3
    Registered User
    Join Date
    12-18-2018
    Location
    Phuket, Thailand
    MS-Off Ver
    Windows 10 - MS Office 2016
    Posts
    47

    Re: Return the Location of Cell

    Wonderful! Thank you Bebo

+ 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. Replies: 5
    Last Post: 03-13-2015, 07:19 AM
  2. return a cell location on search criteria
    By major48 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-14-2014, 02:18 PM
  3. Search multiple worksheets for matching cell value and return cell location as a hyperlink
    By wickedsparrow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2013, 08:47 PM
  4. [SOLVED] Search for Text and Return Cell Location
    By olives in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-17-2013, 07:53 PM
  5. Return active cell's location/row
    By rziegler in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-09-2009, 05:29 PM
  6. Save a cell location and return to it
    By Adam in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-17-2006, 04:41 AM
  7. How can I return the cell location of a hyperlink?
    By vanwerkum in forum Excel General
    Replies: 0
    Last Post: 03-04-2005, 02:25 AM

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