Combo Box Link and VLookup Help

mike2246

New Member
Joined
Jan 13, 2015
Messages
26
Need Help with Combo box linking and VLookup's,
On Player Average I created a Combo Box and was able to have it list all the Players from Players Tab I went into Format Control and Linked it as B1. I would like the player name to show up in Cell A5 on PlayerAvg or if I could just move the Combo Box in the location of A5 and use it the same.

Once the Player Name is in A5, I need a Vlookup to pull the information from that player into B5-K5

The Combo box is pulling the list from Players A4-A104

Also, is there a way to shorten a Number from 40,000 to 40K and still have an auto sum work?
 

Attachments

  • Players.PNG
    Players.PNG
    4 KB · Views: 4
  • Totals.PNG
    Totals.PNG
    56.2 KB · Views: 4
  • PlayerAvg.PNG
    PlayerAvg.PNG
    34.2 KB · Views: 4

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,127,294
Messages
5,623,824
Members
415,991
Latest member
RicardoSS

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
Top