+ Reply to Thread
Results 1 to 2 of 2

Needing Assistance with a Nested Vlookup Statement

  1. #1
    Registered User
    Join Date
    04-16-2014
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    1

    Needing Assistance with a Nested Vlookup Statement

    Long time user of this forum, but first time poster.

    I need a nested formula (assuming vlookup + something) to populate an existing value (aging) from my table array if that value also meets certain criteria (in this case a particular month).

    1. On my detail worksheet I have account data (account number is Lookup Value) for an entire year (thousands of rows / tens of columns). The account number could be listed up to 12 times, but each entry is tied to a specific month. All monthly values are listed in a single column (column index number 11 in this example).

    2. On my summary worksheet I have each account number (Lookup Value) listed only once with a column for each month.

    My lookup values are in the first columns on both the detail and summary worksheets. The aging value and monthly value are in columns 11 and 18 respectively on my detail worksheet. The individual months go from column 2 to column 13 on my summary tab.

    I have tested various scenarios, without success, so your suggestions are welcome.

    Jeff

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,704

    Re: Needing Assistance with a Nested Vlookup Statement

    Welcome to the Forum.

    If you have been browsing for a while you will have seen many requests for sample workbooks, and I think this applies in your case also.

    Pete

+ 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. [SOLVED] Excel novice needing assistance with cumulative totals
    By jlwhitten in forum Excel General
    Replies: 5
    Last Post: 04-13-2014, 08:41 AM
  2. [SOLVED] Needing Help with Nested IF Statement for One OR Two Column Word Answers
    By marybarnes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-16-2013, 07:15 PM
  3. [SOLVED] VLookup nested in If/then statement
    By Mile029 in forum Excel General
    Replies: 3
    Last Post: 08-29-2012, 11:28 AM
  4. Newbie needing assistance
    By Woodchuck75 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-22-2012, 11:33 AM
  5. mathematician dummy needing assistance
    By jevoudraisdire@yahoo.fr in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-21-2005, 05:10 PM

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