Spread sheet is used for very simple accounting purposes. A1=Name, B1=number, C1=number, D1=number
Each name has three sets of number connected to the individual.
The names are chosen from a drop box (A1). I would like to click on a name in the drop box and have the information connected to the name fill B1, C1, and D1 automatically.
I anxiously await your responses.
thank you in advance.
Excel Newbie
PS, don't quite understand "tags".
looks like a VLOOKUP() or INDEX/MATCH() formula, something along the lines of: (Assuming the actual data is in 'Sheet2'. startimng in cell A1, and 1000 rows deep)
=VLOOKUP($A1,Sheet2!$A$1:$D$1000,2,0)---change the '2' to the right column for you
or:
=INDEX(Sheet2!$A$1:$D$1000,MATCH($A1,Sheet2!$A$1:$A$1000,0),2) Again, change the 2 to the right column for you (may be possible for Excel to do this automatically, but without data to see/manipulate, I won't offer that formula)
Hope this helps
Last edited by dredwolf; 04-02-2013 at 01:43 AM.
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Thank you for the information. I had a feeling it was VLOOKUP. I will research this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks