+ Reply to Thread
Results 1 to 11 of 11

Probably INDEX MATCH help needed?

  1. #1
    Registered User
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    2010
    Posts
    90

    Lightbulb Probably INDEX MATCH help needed?

    Dear Experts,

    I have a file with 2 sheets, Sheet 1 contains a table with headers as Employee & the Service name against which they will work progressively. Sheet 2 contains a list of all Employees in Col A who may have worked and their hours in Col B & Col C, for billable & non- billable categories respectively. Then i have Col D where i would like the relative service name to appear based on Sheet 1 input. Please note that the Employee's name may appear multiple times in Col A on Sheet 1.

    Please take time to see the attached sheet & guide me. I need a formula and may not want to use Validation list.

    Thanks,
    Mahesh
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,956

    Re: Probably INDEX MATCH help needed?

    ...and if an employees name appears more than once on sheet 1 is the service name always the same for that employee?

    If yes then a simple VLOOKUP() will do since there's only one result

    If no then there are severl sevice names so what do you want to see in the cells on sheet 2

    It alwys helps to show a truly representative example. At the moment all the names are unique on sheet1 yet you mention they may be duplicated
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    2010
    Posts
    90

    Re: Probably INDEX MATCH help needed?

    Yes, the service name will be the same every time for that employee. Actually on Sheet 1, if you see E-2 appears twice. like this an employee's name may appear many times in Sheet 1 for a respective service & in Sheet 2 i just need the Service name for that specific employee to be pulled up.

    Hope this clarifies

    Thanks

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,956

    Re: Probably INDEX MATCH help needed?

    OK, sorry missed seein E-2 appears twice.

    Nevertheless since the service name for that employee IS unique then a simple VLOOKUP will work just fine.

  5. #5
    Registered User
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    2010
    Posts
    90

    Re: Probably INDEX MATCH help needed?

    Can you help me with the formula please?

    Thanks

  6. #6
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    682

    Re: Probably INDEX MATCH help needed?

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    2010
    Posts
    90

    Re: Probably INDEX MATCH help needed?

    Thank you Shareez...Appreciate your help. Works perfect!

  8. #8
    Registered User
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    2010
    Posts
    90

    Re: Probably INDEX MATCH help needed?

    Hi Shareez,

    Just a thought, incase if an employee works on more than one service, then how should i approach? What formula could i use?

    Mahesh

  9. #9
    Registered User
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    2010
    Posts
    90

    Re: Probably INDEX MATCH help needed?

    Can some expert help here please? Thanks in advance

    Mahesh

  10. #10
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    682

    Re: Probably INDEX MATCH help needed?

    With the help of helper columns:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Use the below array formula (press Control + Shift + Enter) in adjacent cells in a row
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    2010
    Posts
    90

    Re: Probably INDEX MATCH help needed?

    Hi Shareez...can't thank you enough for this...simply superb...this has really helped me a lot!! added rep for your help.

    Mahesh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index Match Help needed
    By St3ff3ns in forum Excel General
    Replies: 8
    Last Post: 10-20-2017, 11:29 AM
  2. [SOLVED] Match and index needed (I think)
    By Agnese in forum Excel General
    Replies: 2
    Last Post: 03-15-2016, 07:50 AM
  3. Index and Match help needed
    By karstens in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-18-2015, 01:34 PM
  4. Second and Third Match on Index Needed
    By excelnoob927 in forum Excel General
    Replies: 0
    Last Post: 11-05-2014, 06:22 PM
  5. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  6. Sum Index Match help needed
    By vhache in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-18-2014, 09:01 AM
  7. Index and Match Help Needed
    By carl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-26-2005, 05: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