I have one spreadsheet comprised of 20 individuals that are identified by a 5
digit number in column A and 10 columns of associated data related to these
individuals. I have another spreadsheet comprised of 1000 individuals
identified by a 5 digit number in column A and 20 columns of associated data
related to these individuals. The people in the first spreadsheet are
somewhere in the second spreadsheet. I need to bring over all 20 columns in
the second spreadsheet over to the first and match by the 5 digit number so
that the 20 individuals have the corresponding 30 columns. I know, long
winded..but hopefully it makes sense..is there a vlookup formula that will
bring over the entire 20 columns based on the 5 digit number?? Any help (sans
Vbasic) would be much appreciated...