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?

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?

That sounds good, but I've been told that vlookups only look at the first row
that matches your lookup field. If I have multiple rows with the same ID#,
will it look at each of those rows for the data?

"Wolf" wrote:

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?

As long as the combination ID#&Address is unique, it will work.
If it happens that you have both the same several times, it will only look
at the first row where it appears.


" Pivot Table/Query" wrote:

That sounds good, but I've been told that vlookups only look at the first row
that matches your lookup field. If I have multiple rows with the same ID#,
will it look at each of those rows for the data?

"Wolf" wrote:

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?

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?