PLEASE HELP>>> Extract data from a single cell on a separate sheet using drop down

%3CLINGO-SUB%20id%3D%22lingo-sub-2106087%22%20slang%3D%22en-US%22%3EPLEASE%20HELP%26gt%3B%26gt%3B%26gt%3B%20Extract%20data%20from%20a%20single%20cell%20on%20a%20separate%20sheet%20using%20drop%20down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2106087%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20an%20Excel%20beginner%20and%20need%20some%20help%20figuring%20out%20how%20to%20extract%20data%20from%20another%20sheet%20based%20on%20a%20drop%20down%20menu.%20I'm%20sure%20its%20fairly%20straightforward%20but%20I%20cant%20figure%20it%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20situation%20is%20that%3B%20I%20have%20a%20drop%20down%20menu%20and%20I%20want%20Excel%20to%20auto%20populate%20from%20specific%20cells%20on%20another%20sheet%20based%20on%20the%20what%20is%20selected%20from%20the%20options%20on%20the%20drop%20down.%20It%20doesn't%20have%20to%20be%20have%20a%20range%2C%20literally%20just%20the%20data%20(Date%20in%20this%20case).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help...!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2106087%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2106132%22%20slang%3D%22en-US%22%3ERe%3A%20PLEASE%20HELP%26gt%3B%26gt%3B%26gt%3B%20Extract%20data%20from%20a%20single%20cell%20on%20a%20separate%20sheet%20using%20drop%20down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2106132%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F946090%22%20target%3D%22_blank%22%3E%40AndyMogstar%3C%2FA%3E%26nbsp%3BCan%20you%20attach%20your%20workbook%2C%20removing%20any%20sensitive%20data%2C%20to%20make%20it%20easier%20to%20understand%20your%20current%20format%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi All,

 

I'm an Excel beginner and need some help figuring out how to extract data from another sheet based on a drop down menu. I'm sure its fairly straightforward but I cant figure it out.

 

The situation is that; I have a drop down menu and I want Excel to auto populate from specific cells on another sheet based on the what is selected from the options on the drop down. It doesn't have to be have a range, literally just the data (Date in this case).

 

Please help...!!!

 

Kind regards,

5 Replies

@Dashdotdash Can you attach your workbook, removing any sensitive data, to make it easier to understand your current format

@adversi Thanks for getting back to me.

I have removed all the data but what heres what I am trying to to:

 

Cell B5 has a drop down and when I select one of the options I would like it to populate Column B with the date on sheet 2 that corresponds with the dropdown selection.

 

E.g.

 

Cell B5 = Entrances

I would like Cell E5 to populate with 28th December from Sheet 2.

 

Does that make sense?

 

@Dashdotdash Here's how the VLOOKUP works, this assumes that the Space column in Sheet2 is where the Column A reference would match

Thanks so much, I was close, my syntax skills are still not up to scratch and just couldn't get it to work.

have a great day.

@Dashdotdash 

 

Video: Create and manage drop-down lists - Excel - Microsoft

https://support.microsoft.com/en-us/office/video-create-and-manage-drop-down-lists-28db87b6-725f-49d...

 

As you have already been recommended, please insert an Excel file / workbook / worksheet (without sensitive data). In this way you can come up with a proposed solution much faster and more precisely. This also helps everyone who wants to help.

 

Hope I could help you at least a little.

 

I would be happy to know if I could help.

 

I wish you continued success with Excel

 

Nikolino

I know I don't know anything (Socrates)