+ Reply to Thread
Results 1 to 3 of 3

Lookup Multiple Occurrence of 2 Values (Date & Qty) in a Row

  1. 09-30-2017, 03:18 PM #1
    Rajeshkumar R
    Rajeshkumar R is offline
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    368

    Lookup Multiple Occurrence of 2 Values (Date & Qty) in a Row

    Dear Experts,

    Need your valuable input on my subjected Query!

    In the attached Workbook:-

    Column A I have Different Item Details; Row No 1 I have Different Date

    Range B2:AJ6 I have Qty against Item in a Row and Date in a Column Respectively

    Column AL to Column AY I have heading i.e. Date (No) & Qty (No)

    Help Required:-

    Whatever Sequential Data I have updated manually in the Range AL2:AY6 i.e. by Item Date1 against it Qty1 Respectively Need to look up for all 7 values (Date & Qty).

    Note : Would request you provide a suggestion in the form of Formula Only (Not in VBA)

    Thanks & Regards,
    Rajeshkumar R
    Attached Files Attached Files
    Last edited by Rajeshkumar R; 10-01-2017 at 02:23 AM. Reason: Query Resolved
    Reply With QuoteRegister To Reply
  2. 09-30-2017, 04:40 PM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,370

    Re: Lookup Multiple Occurrence of 2 Values (Date & Qty) in a Row

    in AL2

    =INDEX($B$1:$AI$1,SMALL(IF($B2:$AI2<>0,COLUMN($B1:$AI1)-COLUMN($B$1)+1,""),(COLUMNS($A$2:A2)-1)/2+1))

    in AM2

    =INDEX($B2:$AI2,SMALL(IF($B2:$AI2<>0,COLUMN($B1:$AI1)-COLUMN($B$1)+1,""),(COLUMNS($A$2:B2)-1)/2+1))

    Copy across in pairs then copy down

    See highlighted cells in attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 10-01-2017, 02:22 AM #3
    Rajeshkumar R
    Rajeshkumar R is offline
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    368

    Re: Lookup Multiple Occurrence of 2 Values (Date & Qty) in a Row

    Dear JohnTopley ,

    Thank You So Much for your instant support, your suggested formula meets exactly my requirement!

    Regards,
    Rajeshkumar R
    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. How to lookup values in two different columns and increment for each occurrence?
    By akray21 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-25-2017, 04:57 PM
  2. lookup Multiple occurances/values between two dates or date range.
    By junior1505 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2016, 11:35 AM
  3. [SOLVED] VLOOKUP Multiple Occurrence for Same Lookup Value
    By Rajeshkumar R in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2014, 02:58 AM
  4. [SOLVED] Lookup Date 14 days prior and add multiple values for that date into column
    By Shylmysten in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-03-2013, 02:15 AM
  5. Counting occurrence of values in multiple columns with one another
    By ebit in forum Excel General
    Replies: 3
    Last Post: 08-20-2009, 06:08 AM
  6. Counting each occurrence of multiple values
    By wublub in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-02-2008, 04:18 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