I have a seperate datebase set up. What I need to do is ... in a seperate
worksheet obtain information for a certain cell and the row that corralates
to be able to feed into a seperate worksheet.


Example:

From Database

Need information that corrolates with column A Row 2 which would be a
registration number. I need the information from ColumnB row 2 (last Name),
Column C row 2 (first name), ColumnG Row 2, (street address) Column H row 2
(city), Colum I row 2 ( State), Column J row 2 (zip Code) , to be
automatically linked to another file so that we do not have to do a copy
paste. I do know of Vlookup but dosen't that only work for picking up info
in the column left of the one you are looking for.

Thanks,
Michelle