Results 1 to 7 of 7

Lookup but Return Range field should be based on Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    Philippines
    MS-Off Ver
    Microsoft Office 365
    Posts
    53

    Lookup but Return Range field should be based on Criteria

    Hello. I need help on lookup formula. The return range is not based on a fixed source.

    E,g, if my criteria is 28-Jan, the return range will be on column B of Lookup Table.
    If my criteria 6-Feb, the return range is column D of Lookup Table.

    Lookup Table 28-Jan 30-Jan 6-Feb 10-Mar
    6-Jan 34,712 15,546 18,521 34,712
    13-Jan 27,342 15,092 16,798 27,342
    20-Jan 25,411 15,319 16,244 25,411
    27-Jan 19,876 15,206 16,930 19,876

    Criteria 6-Jan 13-Jan 20-Jan 27-Jan
    28-Jan 34,712 27,342 25,411 19,876
    30-Jan 15,546 15,092 15,319 15,206
    6-Feb 18,521 16,798 16,244 16,930
    10-Mar 34,712 27,342 25,411 19,876
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple criteria lookup return row range
    By unknown_brother in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2019, 09:23 PM
  2. [SOLVED] Lookup based on 2 criteria to return in table (solved)
    By ChrisDFloyd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-23-2019, 10:55 AM
  3. Lookup based on multiple criteria and return value in column
    By Ariff_Chowdhury in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-01-2019, 10:08 PM
  4. [SOLVED] Lookup a value within a range with 2 additional criteria, return a value
    By gaker10 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-12-2018, 08:17 PM
  5. [SOLVED] V-Lookup based upon multiple criteria to return a value. Or a better way!
    By gboyleuk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-23-2015, 04:21 AM
  6. Lookup/ Return a value within date range base on criteria
    By kelkelkel08 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-16-2014, 05:10 AM
  7. Replies: 10
    Last Post: 02-19-2013, 12:05 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