Results 1 to 7 of 7

Lookup but Return Range field should be based on Criteria

Threaded View

  1. 03-18-2024, 01:03 PM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,419

    Re: Lookup but Return Range field should be based on Criteria

    One guess (until an explanation is forthcoming)...


    =INDEX($B$2:$E$5,MATCH(B$7,$A$2:$A$5,0),MATCH($A8,$B$1:$E$1,0)) in B8, copied across and down.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. 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. Lookup values in multiple columns based on a date range, return single value per criteria
    By mprisbrey in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1