I am building a spreadsheet showing different companies and their information to be able to compare them to each other. I want to have a list that you can choose the company and once chosen then it auto fills the rest of the cells with the information regarding that company. I will attach a spreadsheet showing what i want to do. Any help would be much appreciated.Example Worksheet.xlsx Thanks
I think you need vlookup, where are you storing the information to populate the cells under B3,C3,D3?
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
One way is to use VLOOKUP. First create your table (you started at A45), Col B would be company addresses, C websites, etc. If you make your table columns in the same order as your form, you can use this in B4 for example;
=IFERROR(VLOOKUP(B$3,$A$45:$Q$76,ROW(A2),FALSE),"")
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
iferror()...
show off
LOL, one of the few benefits of Excel 2007.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks