S
sam81 via OfficeKB.com
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 ? ? ? ?
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 ? ? ? ?