I am trying to merge two spreadsheets. One has names and addresses. The
other is a list of items. I would like to match data to the appropriate row
by last name (the variable each sheet has in common). Is there a way to do
that without manually cutting and pasting each row? thanks!