I have many first names in column A and last names in column B and their
corresponding #s farther down in four columns (F:I). I have another list of
first and last names at the bottom of the page which I would like excel look
for thier match in the same sheet and copy the #s from all 4 columns in the
top sheet and paste it to their corresponding columns (F:I) at the bottom
sheet.

I belive it can be done with Vlookup but I can't get it right.

Help please.
Thank you.

EX.

Top of the sheet:

ColumnA ColumnB | ColumnF ColumnG ColumnH ColumnI
Bob newman 6 45 86 52


Bottom of the sheet:

ColumnA ColumnB | ColumnF ColumnG ColumnH ColumnI
Bob newman ? ? ? ?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1