how to get multiple values using lookup reference

[vrkishoree]

hi all,

please review attached excel sheet, in sheet1(ecode) if i give the ecode of employee, i want to get the data from sheet2(data)
corresponding name
and no of process and employee done, How many hours, how much production


by using vlookup i get corresponding name in ecode sheet E4.

but unable to get following
1)no of process employee done.
2)How many hours,
3)how much production

kindly helpprocess.xls

[zbor]

Here, try this:

Please Login or Register  to view this content.

[oeldere]

With a pivot table.

[MarvinP]

Hi vrkishoree,

You need to expand your array range in your vlookup formula. See the attached with the answer.

Also read http://www.techonthenet.com/excel/formulas/vlookup.php for more information about vlookup.

[olasa]

Here are some options. Delete what is not needed.
//Ola

[vrkishoree]

hi All,
i give the ecode of employee, i want to get the data from sheet2(data)
corresponding name
and no of process that employee done should be unique?
how to exclude duplicate process names and get unique process name that employee.

[vrkishoree]

thnaks olasa,

for your clarification, but my problem i want unique process that "ratna" done. how can i get?
Can you please help.

[vrkishoree]

Here are some options. Delete what is not needed.
//Ola

thnaks olasa,

for your clarification, but my problem i want unique process that "ratna" done. how can i get?
Can you please help.

[olasa]

Is this what you are looking for?
//Ola

process.xlsx

[vrkishoree]

Is this what you are looking for?
//Ola

Attachment 165529

hi olasa,

Thanks for your assistance, this function is so useful and i looking for this only.

Thanks a lot.

[olasa]

Good to hear.
//Ola