You could create a pivot table off the data

" Pivot Table/Query" wrote:

I have rows of data that contain the following
column data
b person id#
e address
p date moved in

there are possibly multiple rows of data for each person's id, if they have
moved more than once. I need to do a vlookup to look at a person's id#, &
address & bring back that move in date. How do I accomplish this?