VLOOKUP 2 CELLS
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?
|