Excel formulas

I assume you're meaning "Row" as in "What row of seats does this student sit in?" Without seeing what your sheets actually look like, it's hard to write the formula. But it occurs to me that you don't really need two sheets in order to have one sorted alphabetically, another by classroom. Excel has a "Sort" function, under Data...Sort, and that allows you to sort by any of the columns in the list. So you could have an alphabetical sort and then switch to classroom sort of the same list AND that list could include the Row data that apparently is in the one but not in the other. For some reason I'm not seeing the ability to upload a sample sheet right now as I write this reply... but if you highlight a list that includes two or three columns and then go to the "Data" menu item at the top of your screen, click on it, and you'll see "Sort" as one of your options. Clicking on that will give you the choice of columns to sort by, whether increasing or decreasing. You can have secondary and tertiary sorts..... Write back if this doesn't make sense.