SOLVED

Drop Down Box

%3CLINGO-SUB%20id%3D%22lingo-sub-2903769%22%20slang%3D%22en-US%22%3EDrop%20Down%20Box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2903769%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20have%20one%20drop%20down%20box%20populate%20cells%20with%20different%20information%20determined%20by%20what%20is%20selected%20in%20the%20drop%20down%20box.%20For%20example%3B%3C%2FP%3E%3CP%3EIf%20I%20select%20Tim%20from%20the%20drop%20down%20box%20the%20in%20row%203%20I%20would%20like%20Tim's%20Information%20displayed.%3C%2FP%3E%3CP%3EUsing%20the%20same%20drop%20down%20box%20if%20I%20select%20Don%20I%20want%20Don't%20information%20displayed%20in%20row%204%2C%20and%20so%20on%20through%20row%20300.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2903769%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2903813%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20Down%20Box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2903813%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F491902%22%20target%3D%22_blank%22%3E%40DaCrab_101%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20VLOOKUP%20(or%20XLOOKUP%2C%20if%20you%20have%20Microsoft%20365%20or%20Office%202021)%20to%20look%20up%20information%20for%20the%20person%20selected%20in%20the%20drop-down.%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EVLOOKUP%20function%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-vlookup-function%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EExcel%20VLOOKUP%20Function%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I would like to have one drop down box populate cells with different information determined by what is selected in the drop down box. For example;

If I select Tim from the drop down box the in row 3 I would like Tim's Information displayed.

Using the same drop down box if I select Don I want Don't information displayed in row 4, and so on through row 300.

 

3 Replies

@DaCrab_101 

You can use VLOOKUP (or XLOOKUP, if you have Microsoft 365 or Office 2021) to look up information for the person selected in the drop-down.

See VLOOKUP function and Excel VLOOKUP Function 

Yes I'm familiar with both. Every play Golf? I'm trying to design a portable Scoring Card for the guys I play with. At the top of the Card is a Drop Down Box. So by selecting Tim, VLOOKUP goes and finds Tim, displays his name on Row 3 Cell A, displays his Handi-Cap Row 3 Cell B. No problems there. Now I want to go back to the same Drop Down Box and select another player to be displayed on Row 4, Cell A & B, just like Tim. Problem is, at least for me, every time you select a new name on the names become the same on Row 3 and Row 4.
best response confirmed by DaCrab_101 (Occasional Contributor)
Solution

@DaCrab_101 

You should use a data validation drop-down in column A, so that each cell can hold a different name.

The formulas in the columns to the right should refer to the cell in column A in the same row.