+ Reply to Thread
Results 1 to 11 of 11

Probably INDEX MATCH help needed?

  1. #1
    Forum Contributor
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    MS Office 365
    Posts
    136

    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 - RIP 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
    29,464

    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

    RIP - d. 06/10/2022

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

  3. #3
    Forum Contributor
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    MS Office 365
    Posts
    136

    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 - RIP 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
    29,464

    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
    Forum Contributor
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    MS Office 365
    Posts
    136

    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
    696

    Re: Probably INDEX MATCH help needed?

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

  7. #7
    Forum Contributor
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    MS Office 365
    Posts
    136

    Re: Probably INDEX MATCH help needed?

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

  8. #8
    Forum Contributor
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    MS Office 365
    Posts
    136

    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
    Forum Contributor
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    MS Office 365
    Posts
    136

    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
    696

    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
    Forum Contributor
    Join Date
    12-18-2015
    Location
    Mumbai, India
    MS-Off Ver
    MS Office 365
    Posts
    136

    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. [SOLVED] 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