Forum Discussion
PLEASE HELP>>> Extract data from a single cell on a separate sheet using drop down
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
Video: Create and manage drop-down lists - Excel - Microsoft
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)
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 https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1, this assumes that the Space column in Sheet2 is where the Column A reference would match
