Results 1 to 7 of 7

Nested INDIRECT Command Not Populating Correctly

Threaded View

lordfa9 Nested INDIRECT Command Not... 02-17-2014, 10:21 PM
vlady Re: Nested INDIRECT Command... 02-17-2014, 10:33 PM
lordfa9 Re: Nested INDIRECT Command... 02-17-2014, 11:20 PM
Tony Valko Re: Nested INDIRECT Command... 02-17-2014, 11:25 PM
lordfa9 Re: Nested INDIRECT Command... 02-17-2014, 11:27 PM
Tony Valko Re: Nested INDIRECT Command... 02-17-2014, 11:40 PM
vlady Re: Nested INDIRECT Command... 02-17-2014, 11:30 PM
  1. #1
    Forum Contributor
    Join Date
    05-07-2007
    Location
    Singapore
    MS-Off Ver
    2006/2016
    Posts
    174

    Nested INDIRECT Command Not Populating Correctly

    Please refer to my screenshot.

    The formula in question is:
    =N$4*VLOOKUP($B5,'BOM MATRIX'!$A$2:$AJ$500,INDIRECT("N3"),FALSE)
    which is currently keyed into cell N5

    what I'm trying to do is to populate rows sideways so for example the formula in cell O5 should be:
    =O$4*VLOOKUP($B5,'BOM MATRIX'!$A$2:$AJ$500,INDIRECT("O3"),FALSE)

    problem is whenever I copypaste. The first part (N$4-> O$4) populates correctly while INDIRECT("N3") remains the same even though it should be INDIRECT("O3") instead

    Is there anything I can do to fix this?
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Simple nested IF statement not working correctly
    By bassemsaad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2013, 08:53 AM
  2. why doesn't this INDIRECT resolve correctly?
    By hank_t in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2012, 04:06 PM
  3. VBA range not populating correctly
    By Squirrel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2011, 11:41 AM
  4. Command button not populating correctly
    By taichi56 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2009, 10:32 AM
  5. Pivot Table Not Populating Correctly
    By Kumara_faith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2008, 08:23 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1