Combining information from two sheets into fixed rows on sheet 1.

[WillisJones]

In sheet 1, I have a master list of students. Sheet 2 is pulled from a database of an online quiz that records their presence or absence at the particular class. Sometime, students do not fill out the online quiz, therefore their name does not appear in sheet 2. Consequently, I cannot figure out how to combine the two sheets in any type of automated way. I would like for the names in sheet 2, to appear under their respective names in sheet 1. If the name is not there, I need the row to remain blank. I have tried custom sort, but that doesn't because if a name does not appear on sheet 2, it continues the sort instead of leaving that row blank. Is it possible to paste and sort, or refer to sheet two in that manner? I have attached an example. Thanks!

[darknation144]

Example #2.xlsx

Here is one solution. Can you be more clear about what you want from the combination of the two sheets?

[BarryTSL]

Another example - The line underneath is read from sheet 2. If name not found row stays blank and the cells above will format to yellow if different from Sheet 1 results. If the names stay the same not a problem but if you are going to add to them you may want to think about using dynamic name ranges.

[WillisJones]

BarryTSL, Thanks! That is exactly what I was trying to do. Still not sure how you formatted the cells to turn yellow if different, but that also helps alot. Were you manually copying the

=IFERROR(VLOOKUP(A2,Sheet2!$A$2:$A$410,1,FALSE),"")

on every other line, or is there a way to automate that? I think I understand the code, but I'm not sure if I need to manually do that on every other line. Thanks!

[BarryTSL]

Turn the cells yellow using the conditional formatting, if you look in "manage rules" you will see the formula, but easy enough to use the "format painter" brush. And yes I just copied one row of the cells (A3 to F3 ) for example with the formlas in and pasted them in every other row. If you use one hand on Ctrl V and the other on the down arrow it won't take you long.

[WillisJones]

Thanks! You helped me out of a jam.

[WillisJones]

darknation144
Thanks! Sorry I wasn't clear about what I needed. The response after yours has the solution I was looking for.