I am trying to build a form that allows a user to select a name in one field using a drop down box selection that will then populate three other fields with info that corresponds to a specific persons name.
I have attached a spreadsheet with the data and the start of the form.
I have tried different formulas and none have worked.
Any help would be greatly appreciated.
Thanks
chiefgbQuote_Pricing form v2.xlsx
Hi, welcome to the forum
2 ways to do this...
1. using vlookup
=VLOOKUP($D$3,DATA2!$A$2:$D$25,1,0)
change ,1, to ,2, etc for the different columns
2. using INDEX/MATCH
=INDEX(DATA2!$B$2:$D$25,MATCH($D$3,DATA2!$A$2:$A$25,0),MATCH(G3,DATA2!$B$1:$D$1,0))
No adjustments needed, just make sure your headings all match (remove the # from Employee number#)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You need to make sure the labels match what is found on your headers on DATA2 and then these would be your formulas.
Example of label corrections - Employee ID#, you either need to remove the # sign or add it to the DATA2 Labels
J3
J5
Please Login or Register to view this content.
D5Please Login or Register to view this content.
Please Login or Register to view this content.
-If you think you are done, Start over - ELeGault
FDibbins Strikes again...lol
Thank you this is perfect... Easy for you guys. I spent a couple of hours trying to get it to work.
I may need more help later on as I complete the template.
Thanks again
chiefgb
ELeGault, nice 1, and I only beat you by 3 mins lol
@ cheifgb, you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
Also, look forward to seeing your next question
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks