Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-10-2017, 09:24 AM
jbd21 jbd21 is offline Help w/ Drop Down Lists Windows 10 Help w/ Drop Down Lists Office 2016
Novice
Help w/ Drop Down Lists
 
Join Date: Jan 2017
Posts: 3
jbd21 is on a distinguished road
Default Help w/ Drop Down Lists

Hello,

I am not sure if this is even possible to do but i'm keeping my fingers crossed.



basically lets say I have data in row 1-5 and col A-D in one sheet1. In sheet2 I want to have a drop down list set up so that when select the item in the drop down list that corresponds to cell A1 in sheet 1, the other data that is in the remainder of the rows and columns would populate as well. Does that make sense?

So say in the drop down menu I have names, and in the table setup for the drop down list I would have the name, address, age etc. So when I select a name, I want to have the rest of the info corresponding to that name populate on its own.

Is this possible? I am not good with VBA so can this be done without using code? I was thinking of doing it with VLOOKUP but the problem i am having is that some of the names would be the same so the formula would not be able to tell the difference.

I am not a pro at excel, so there might be an easy way to do this or it might be complicated. I am not sure..

Any help it will be highly appreciated.

thanks.
Reply With Quote
 

Tags
drop down list, vlookup



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help w/ Drop Down Lists Drop down lists options inq80 Excel 2 10-17-2014 08:05 AM
Multiple Drop Down Lists in word ali212006 Word 3 03-13-2013 12:16 PM
Dependent drop down lists bobbych Word 1 02-08-2013 04:38 PM
Help w/ Drop Down Lists Drop-down lists in Excel Maureen Excel 1 11-10-2011 08:11 AM
Drop Down Lists Browett Excel 0 12-19-2005 04:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft