Results 1 to 9 of 9

with the combination of two selections get all the values pertaining to them in excel

Threaded View

  1. #1
    Registered User
    Join Date
    03-28-2014
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    66

    with the combination of two selections get all the values pertaining to them in excel

    Excel 2016 :
    "PartData" sheet stores data and data is fetched from here. Print Report is the sheet where I select Emp No & Set No and get the data automatically in A23 to F28.
    When I select Emp no & Set No (A3 & B3) , it automatically fetches Previous Set No. (in D22) & Count of Lines (in F22 - number of lines the combination of emp no & set have) from the PartData Sheet.

    I need help on the followings : With the combination of Emp no (A4 ) and Previous Set No.( D22) and I want to get values of
    Previous Items (the data will come from PartData: Column D:D),
    Previous items Make (the data will come from PartData: Column J:J),
    Previous Expense (the data will come from PartData: Column H:H)

    A sample file (Trial.xls) is attached for your kind perusal. Please help me.
    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. [SOLVED] Help Populating a Cell Dependent on Combination of Drop Down List Selections
    By kitkatplaya in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2019, 09:34 AM
  2. [SOLVED] Formula to Extraxt email addresses in Col B pertaining to name in Col A
    By flupsie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-17-2018, 11:01 PM
  3. Count values in a row pertaining to a specific date range column
    By MattStolz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-23-2015, 03:21 PM
  4. Need more help pertaining to the hotel occupancy worksheet
    By TheVodkaDude in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-06-2013, 02:30 AM
  5. IF Statments pertaining to dates and if it lands on a Saturday or Sunday
    By RanS2011 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-22-2013, 11:30 AM
  6. Macro help pertaining to compare
    By lorenzoscott78 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2013, 06:33 PM
  7. Replies: 3
    Last Post: 02-13-2012, 03:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1