N/APosted 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.
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.