Need some kind of

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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.