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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 20, 2009 at 08:33 PM
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 20, 2009 at 08:33 PM
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.
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.