Linking dynamic data with drop down

Ashley W

New Member
Joined
Oct 22, 2015
Messages
3
Hello all,

Not a star excel user but am trying hard to increase my knowledge:)

Have a situation here where am trying to link dynamic data from a drop down list (Based on a sales rep name Cell A17) so that it returns the exact 2 top customers names based on the total product sold.
AM stuck with following formulae =VLOOKUP(LARGE(B3:B14,1),B3:$D$14,3,FALSE) and not able to find out how to link it to the drop down.
What am looking for is for Sales rep Estelle, the result is the name for her top 2 customers. Thus result being CAR LTD and Apple LTD.

Thanking you in advance.

1ABC
2No of Products SoldSales RepresentativeCustomer Name
3120MikeAirplane Ltd
410EstelleApple LTD
530LalanirinaBanana LTD
690LalanirinaBicycle Ltd
7100KhadeejaBoat Ltd
880HeriBus Ltd
970EstelleCar Ltd
1040KhadeejaKiwi LTD
1160MikeLitchi LTD
1250Yoshini Mango LTD
13110Yoshini Motorcycle Ltd
1420HeriOrange LTD
15
16Sales Rep
17Estelle
18
19Top 2 Customers per Sales Rep
20Airplane Ltd
21Boat Ltd

<tbody>
</tbody><colgroup><col><col span="2"><col></colgroup>
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top