Results 1 to 5 of 5

look up with multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2015
    Location
    hong kong
    MS-Off Ver
    ms 2010
    Posts
    16

    look up with multiple criteria

    Sheet 1 full list
    Sheet 2 list of student taking more than one type of lessons

    I want to show the lesson time in sheet 2 column c. The criteria are sheet 2 column a and b. I want the formula can be copied down to the last row. How can I do that?

    Some of the students having double sessions for the same instrument will have two individual entries, so remove duplicate cannot suit my needs.

    Thank you.
    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. Replies: 9
    Last Post: 07-23-2015, 01:21 PM
  2. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  3. [SOLVED] countifs statement with multiple criteria for multiple criteria ranges
    By mcdermott2 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-07-2015, 11:48 AM
  4. [SOLVED] UDF for sum of multiple criteria in multiple columns and single criteria in multiple colum
    By Ganesh7299 in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 11-22-2013, 04:26 AM
  5. Count statement wtih multiple criteria only showing results for one criteria
    By uhlabomber in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2013, 02:47 PM
  6. Replies: 2
    Last Post: 10-05-2011, 12:43 PM
  7. MACROS: Sort by multiple criteria - Create tabs based off of criteria
    By svineyard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2009, 10:48 AM

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