I need a selection from a drop down list to autopopulate other options.
For example: I have a sheet with the company name, address, etc. In another sheet, I enter a contact name. I then want to choose a company name from the drop down list and the rest of the information to automatically populate across the cells. I'm using a table for the company name, but which set of functions do I use after that?
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Here is a mock up of what I am looking for
Thank you
I am bit confused. 1. I do not find a drop down box. 2. Which sheet are you selecting and 3. Which sheet should be populated. It is not exactly clear which is which. Please clarify with specific instructions/request.
CompanySheet does not have any drop boxes
ContactSheet - DropList seems to only be in B2 - it should be in the whole column
eg if I choose Company ABC from the drop box for B4, C4 should pull PO Box 4 (as input in B3 on the CompanySheet), D4 should pull Windsor, etc.
Projects Sheet - Project# will be a manual input. CompanyName from a drop down list followed by address autopopulating based on information in CompanySheet. ContactName from a drop down list followed by ContactPhone & ContactCell autopopulating from ContactSheet
In C2, type =IFNA(VLOOKUP($B2,Company!$A$2:$K$2,3,0),"")
Copy this over to all cells you wish to fill, changing the highlighted number in the forumula 1 up for each adjacent cell, ie.
in D2, it would appear as =IFNA(VLOOKUP($B2,Company!$A$2:$K$2,4,0),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks