Hey,
So i'm going crazy here. I've watched videos, I've searched the web and this forum, and nothing is working. I am trying to do a vlookup with multiple sheets and I need to use a text criteria to lookup the results.
I created a concatenated column in both sheets and put it as the left-most column. This should serve as my identifier. I also removed duplicates on the second sheet. I am then trying to create a vlookup that will look at sheet 1 to see what classes certain students have. I want the look up to do lookups via text. For example, when it contains the words math, english, algebra, etc. I have a lot of cells that need to be sorted so I don't want to do it by hand. What are the forumlas needed for ELA Period Name, ELA Teacher First, ELA Teacher Second, etc? Thank you!!!!!!
For example:
Table 1: Roster ANET
<tbody>
</tbody>
Sheet 1:
<tbody>
</tbody>
So i'm going crazy here. I've watched videos, I've searched the web and this forum, and nothing is working. I am trying to do a vlookup with multiple sheets and I need to use a text criteria to lookup the results.
I created a concatenated column in both sheets and put it as the left-most column. This should serve as my identifier. I also removed duplicates on the second sheet. I am then trying to create a vlookup that will look at sheet 1 to see what classes certain students have. I want the look up to do lookups via text. For example, when it contains the words math, english, algebra, etc. I have a lot of cells that need to be sorted so I don't want to do it by hand. What are the forumlas needed for ELA Period Name, ELA Teacher First, ELA Teacher Second, etc? Thank you!!!!!!
For example:
Table 1: Roster ANET
LastNumber | First_Name | Last_Name | Middle_Name | Eth | Gender | DOB | Number | Grade | Course_Name | Teacher First | Teacher Last |
Johnson12345 | Brad | Johnson | - | m | 1/1/1111 | 12345 | 6 | ELA 6 | John | Smith | |
Luther-7890 | Lex | Luthor | - | M | 2/2/2222 | 7890 | 6 | Math 7 | Al | Gore | |
Johnson12345 | Brad | Johnson | - | m | 1/1/111 | 12345 | 6 | Algebra 1 | Thomas | Jefferson |
<tbody>
</tbody>
Sheet 1:
LastNumber | First_Name | Last_Name | Eth | Gender | DOB | Number | Grade | ELA Period Name | ELA Teacher First | ELA Teacher Second | Math Period 1 | Math Teacher First | Math Teacher Second | |||
Johnson12345 | Brad | Johnson | - | M | 1/1/1111 | 12345 | 6 | |||||||||
<tbody>
</tbody>