Checking for members

  • Thread starter Thread starter Nemesis
  • Start date Start date
N

Nemesis

Since my Excel skills are limited I urgently need your help.

I'm currently trying to keep track of what study courses our member
have taken. I have a five digit member number.

I want to create seperate sheets for every member, telling me wha
courses they've taken, from the list where I enter the courses.

In the A column I have the member's number and in the second I have th
member's name. I want to search column A for the member's number and i
it's found in column A it should look up what it says on the same ro
but in column K, and then copy that into the designated sheet.

In short I need a formula searching one column for a number, if foun
it should check another column and copy that information (text) int
another sheet.

Hopefully someone will understand this problem and will be able to hel
me out
 
Nemesis > said:
Since my Excel skills are limited I urgently need your help.

I'm currently trying to keep track of what study courses our members
have taken. I have a five digit member number.

I want to create seperate sheets for every member, telling me what
courses they've taken, from the list where I enter the courses.

In the A column I have the member's number and in the second I have the
member's name. I want to search column A for the member's number and if
it's found in column A it should look up what it says on the same row
but in column K, and then copy that into the designated sheet.

In short I need a formula searching one column for a number, if found
it should check another column and copy that information (text) into
another sheet.

Hopefully someone will understand this problem and will be able to help
me out!
Click to expand...

The direct answer to your question is that VLOOKUP is the function for you
to look at; full details are in help. However, this returns data from the
first match found, whereas I assume each of your members could have several
courses listed. To get data from subsequent matches you would need other
formulas (one for each possible match). Take a look here in the paragraph
"Arbitrary lookups" for how to construct such formulas:
http://www.cpearson.com/excel/lookups.htm

I must say, however, that this whole idea seems excessively complicated to
me. Why do you have to create all the extra worksheets? If you need a five
digit member number, I assume that you have (or could have) over 999
members, which is a huge number of worksheets! What is wrong with simply
sorting the one worksheet by member number, so that any member's courses
appear on adjacent lines?
 
This is exactly what I needed. The problem is that this "prgram" wil
not be used by myself, but by someone who doesn't know too much abou
computers and how diferent programs work. And she needs to be able t
sort each member out, from time-to-time in order to present thei
progress. That's why I need this solution. Otherwise I would have jus
sorted each and every member in adjascent lines.

Thank you again Paul
 
Back
Top