I've got 2 sheets, both of which have a column of 1500+ names, followed
by some columns of other info. The list of names in the two sheets are
mostly the same, but not every name will be in each list.

Sheet 1 also contains a 'Flag' column which will have either an "X" in
it or will be blank. List 2 also has the 'Flag' column but all fields in
it are blank.

For every name in Sheet 1 that has a matching name in Sheet 2, I need to
copy over the corresponding 'Flag' value, leaving the other data in
Sheet 2 intact and ignoring any names from Sheet 1 that aren't already
in Sheet 2.

For example:

Sheet 1 contains:
Doe, John    X    other sheet1 stuff
Jones, Sue          other sheet1 stuff
Smith, Bill    X    other sheet1 stuff  <- unique to S1
Wood, Jim  X    other sheet1 stuff

Sheet 2 contains:
Doe, John          other sheet2 stuff
Jones, Sue         other sheet2 stuff
Lee, Bob           other sheet2 stuff  <- unique to S2
Wood, Jim         other sheet2 stuff

I need to end up with:
Doe, John    X      other sheet2 stuff
Jones, Sue            other sheet2 stuff
Lee, Bob              other sheet2 stuff
Wood, Jim    X     other sheet2 stuff

How (using Excel 97 or 2000)?