VLOOKUP 2 CELLS
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? |
VLOOKUP 2 CELLS
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? |
VLOOKUP 2 CELLS
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? |
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? |
VLOOKUP 2 CELLS
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? |
All times are GMT +1. The time now is 12:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com