599CD.com - Forums - Microsoft Excel Forum

599CD Forums home admin

Microsoft Excel Forum

This forum is for the discussion of Microsoft Excel.

To Subscribe to this forum and receive an email update whenever new posts are added, just scroll down to the bottom of this page and enter your email address in the comment form.

Keywords: microsoft excel forum

Post New Topic

Read MATCHING 5 COLUMNS FROM TWO SHEETS by ELIZABETH @ Thu 8/26

Read excel Find option by Nikki @ Sun 8/22

Read conditional formatting by Larry @ Sun 8/22

Read Split numbers in a cell into different cells by Kim @ Wed 8/18

Read Excel by Kim de Sylva @ 7/29/2010

Read if statement by Chris @ 7/27/2010

Read Complex Formula - Hope you can help by David @ 7/27/2010

Read Excel Help by Parker @ 7/27/2010

Read Adress in excell by Adrian @ 7/27/2010

Read Time calculations by Lorrie @ 7/23/2010

Read Complex Formula - Hope you can help by David @ 7/20/2010

Read add days to a date on a different spreadsheet by Emily @ 7/20/2010

Read excel formula b/t 2 sheets by Adrienne @ 7/12/2010

Read How to multiply by Travis Livingston @ 7/7/2010

Read Protecting cells by Merle Crowe @ 7/1/2010

Read data validation for noncontiguous cells by steve @ 6/28/2010

Read Cut and Paste Locked Cells by Kevin @ 6/21/2010

Read Change color of cell or row if a date is ente... by Vince @ 6/21/2010

Read Show Automatic additional info by Moshe @ 6/19/2010

"Hi,
I am making a database in MS excel of people that are members of my club that are contributing money to the club, now there are few 100 members and they are constantly making contributions, now when anyone makes a contribution I do not want to have to enter all his personal info (which includes Last name, First name, Home phone number and Cell number), instead I want to enter all of them one time somewhere on the spreadsheet and set up that whenever I put in (lets say) the Acronym of the person in column A I should automatically get Last name in column B, First name in column C, Home phone number in column D, Cell number in column E, and then I just have to enter the amount that the person contributed in column F.

Please let me know if there is a way to do so.
Thanks"

Answer from Richard Rost:

This is EXACTLY why you should use a DATABASE like Microsoft Access instead of a spreadsheet like Excel. In Access you can have two tables: one for your contributors, and another for their contributions. Then you can RELATE the two of them together so you only need to enter the contributor information ONCE and link it to their contributions.

However�

If you really want to do this in Excel, just make Sheet1 for your contributors and assign each of them an ID of some kind� like their first initial and the first 4 letters of their last name.

Now on Sheet2, list their contributions and make sure to include that ID that you created for each person on Sheet1.

Then you could use the VLOOKUP function to pull the rest of their data from Sheet1 into Sheet2 if you must. I'll include a tutorial (below) for you on VLOOKUP.

However, again, Excel really isn't designed for this. I would strongly recommend learning how to build a simple database in Access (if you have it available) if you need to track this kind of information.

You can use the VLOOKUP or HLOOKUP function.

VLOOKUP is a powerful function in Microsoft Excel that allows you to look up a value from another spreadsheet - or a smaller subtable (lookup table).

See this FREE tutorial for help with VLOOKUP:

http://599cd.com/tips/excel/vlookup/?key=BlFAlEx

Show Just This Thread Post Reply

Read Setting fonts by Jeff @ 6/5/2010

Show Older Posts Expand All Topics

Post Your Comments or Subscribe
If you would like to be notified of new posts on this forum,
just enter your email address below. It will be kept private.

Your Name:

Shown

Your Email:

NOT Shown

Subject:

Comments:

Notify me when the this forum is updated

Remember Me for my next comments

Are you a human?
Type in the word you see to the left:

Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be. I just ask for your email address so I can contact you back, if necessary. As always, I promise to never give away your email address.

599CD Forums home admin

hide help