Customize lookup option in Excel

Asked By diegobro 0 points N/A Posted on - 12/12/2011

Can you please help me on how to customize the lookup application in Excel? I’m trying to have a list of different names with highest commission for the month using the lookup function. So I added additional boxes for those other names having the same rate of commissions but only one person’s name appears on those boxes. Help please.

• Status: Open
• Question Views: 1002
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By maninderkalsi 0 points N/A #99713

Customize lookup option in Excel

What I understand is that you have 2 columns with first column having commission earned and the second column contains the name of the person and you want to make a table with commission earned in first column and the names of the persons in the consecutive columns. Well this cannot be done by lookup, you would be required to use the pivot function in excel.

1. First select your table array which contains the data.

2. Go to Insert Tab and select Pivot Table option and then Pivot Table in sub option

3. Then click OK in next dialogue box

4. then in Pivot table field list drag commission earned and names in Row Labels field.

I hope this will solve your problem.

 

About maninderkalsi

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 12/18/2011
• Question Category: MS Excel