You may include an additional column in your table and put in the formula e.g.
= B2&E2.
In the vlookup-formula you have to put in the lookup-value in the same way,
concatonating "person id#" and "address".

Wolf

" 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?