+ Reply to Thread
Results 1 to 3 of 3

Issue with Offset/ Match formula that references a variable row and cell

  1. 04-21-2020, 10:26 AM #1
    Grilleman
    Grilleman is offline
    Forum Contributor
    Join Date
    04-11-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    245

    Issue with Offset/ Match formula that references a variable row and cell

    So I'm still having trouble trying to get my formula to work. The formula needs to reference the last cell with a value in column "J". If I replace ... LstRw & 10... with ... Data!$J$2 (a relative cell reference)..., the formula works fine. However, my data worksheet will contain a varying number of rows.

    See my attached sample workbook.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-21-2020, 10:44 AM #2
    Bernie Deitrick
    Bernie Deitrick is offline
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,945

    Re: Issue with Offset/ Match formula that references a variable row and cell

    The best way to resolve formula creation issues is to actually get the formula to work: you said that replacing LstRw & 10... with ... Data!$J$2 works:

    Please Login or Register  to view this content.
    So, to incorporate LstRow & 10 to create the $J$10 part

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010
    Reply With QuoteRegister To Reply
  3. 04-21-2020, 08:25 PM #3
    Grilleman
    Grilleman is offline
    Forum Contributor
    Join Date
    04-11-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    245

    Re: Issue with Offset/ Match formula that references a variable row and cell

    That does it! Thanks for the learning. I knew this was a syntax issue. Thanks again.
    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. Dynamic formula with offset and match Issue please help.
    By ebitda_traps in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-04-2019, 06:44 PM
  2. Offset(Match Formula Issue
    By maske002 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-31-2018, 12:53 PM
  3. [SOLVED] How to autofill a formula when the cell references are variable.
    By Lumisheep in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-07-2016, 01:18 PM
  4. issue with Offset & Match
    By illusionek in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 05-28-2016, 08:51 AM
  5. Counta(Offset...)) works in cell but not named formula; cell references are not relative.
    By January1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-12-2014, 02:42 PM
  6. Need to add iftext in relative cell refrence to a offset(match+match) formula
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2014, 02:13 PM
  7. variable Cell references within formula
    By Macatk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2009, 08:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1