+ Reply to Thread
Results 1 to 4 of 4

formula wont use data in referenced cell as a range lookup

  1. 01-29-2020, 06:26 PM #1
    CityMPLSEmpolyee
    CityMPLSEmpolyee is offline
    Forum Contributor
    Join Date
    09-30-2010
    Location
    Minnesota, USA
    MS-Off Ver
    Excel 2010
    Posts
    109

    formula wont use data in referenced cell as a range lookup

    formula wont use data in referenced cell H2 as a range lookup cell H2 has this text in it ('Project Area 01'!$DM$3:$DM$30)
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Last edited by CityMPLSEmpolyee; 01-30-2020 at 10:15 AM.
    Reply With QuoteRegister To Reply
  2. 01-29-2020, 06:43 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,552

    Re: formula wont use data in referenced cell as a range lookup

    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 01-30-2020, 10:11 AM #3
    CityMPLSEmpolyee
    CityMPLSEmpolyee is offline
    Forum Contributor
    Join Date
    09-30-2010
    Location
    Minnesota, USA
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: formula wont use data in referenced cell as a range lookup

    Thank you
    this worked
    Reply With QuoteRegister To Reply
  4. 01-30-2020, 12:18 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,552

    Re: formula wont use data in referenced cell as a range lookup

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. my macro wont fire when data is inputed from an external source or a cell with a formula
    By 10marshallb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-20-2019, 01:36 PM
  2. [SOLVED] Cell references in formula keep changing when moving data in referenced cells
    By sam beginer in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-21-2013, 09:56 PM
  3. lookup 2 columns that are data validated wont return correct info
    By imatthews2001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2011, 02:31 PM
  4. Lookup cell value in referenced worksheet
    By Popa in forum Excel General
    Replies: 2
    Last Post: 06-30-2009, 10:56 AM
  5. [SOLVED] Excel formula timestamp for a data entry of a referenced cell
    By jmasaki in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2006, 09:25 PM
  6. Formula Changes when data entered in referenced range
    By mac849 in forum Excel General
    Replies: 5
    Last Post: 03-20-2005, 10:06 PM
  7. Defining a range in a cell so it can be referenced in a formula
    By SandyUK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2005, 04:58 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1