Previous Topic Next Topic

Need some kind of

Closed
Maureen - Nov 20, 2009 at 10:42 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 20, 2009 at 08:33 PM 
Hello,

I have a spreadsheet with information concerning class ID numbers and attendees but it also contains multiple rows for dates.

I want to present the information in a more meaningful way, so that the ID numbers are replaced with the class name.

For example I have a table like this:

Class ID     Class Name
1              English
2              Math
3              Science
4              History

Then my actual data looks like this:

Date    Class ID     Attendees
10/14     1                 5
10/15     1                 3
10/16     3                 4
10/17     2                 3
10/18     2                 5
10/19     4                 3


I want to replace the Class ID numbers with the matching text names. I could use a search and replace but in reality the class list is about 30 items long and it seems there must be a formula that could accomplish this.

Is this possible?

thanks a bunch,

Maureen

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 20, 2009 at 08:33 PM
Where is the table giving the subject name for each symbol suppose it is in range
F1:G5 including column headings .

I also suppose the actual data is A1LC7
Date Class ID Attendees
14-Oct 1 5
15-Oct 1 3
16-Oct 3 4
17-Oct 2 3
18-Oct 2 5
19-Oct 4 3

IN D2 type this formula (or copy paste)
=VLOOKUP(B2,$F$1:$G$5,2,FALSE)
copy D2 down. you will get like this

Date Class ID Attendees
14-Oct 1 5 English
15-Oct 1 3 English
16-Oct 3 4 Science
17-Oct 2 3 Math
18-Oct 2 5 Math
19-Oct 4 3 History

dO NOT DELETE COLUMN B

READ HELP FOR VLOOKUP FUNCTION. tHIS IS A USEFUL FUNCTION WHICH YOU CAN USE ON MANY OCCASIONS.
0