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

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.

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!

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.

Thanks! You helped me out of a jam.