# Probably INDEX MATCH help needed?

1. ## 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

2. ## 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

3. ## 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. ## 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. ## Re: Probably INDEX MATCH help needed?

Can you help me with the formula please?

Thanks

6. ## Re: Probably INDEX MATCH help needed?

Formula:
`Please Login or Register  to view this content.`

7. ## Re: Probably INDEX MATCH help needed?

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

8. ## 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

Mahesh

10. ## Re: Probably INDEX MATCH help needed?

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

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

11. ## 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

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