Combining Non-numerica data from multiple sources
 

I need to consolidate data (non numerical data) together. In Sheet #1
(NAMES) I have three columns. The first is a unique key "PAXID" followed by
"Last Name" and "First Name". On Sheet #2 (ADDRESSES) I have the same
"PAXID" column followed by "Address Line 1", "Address Line 2", City",
"State", and "Postal Code"

I need to join all these fields into a single sheet that would have PAXID,
Last Name, First Name, AddressLine1, AddressLine2, City, State and Postal
Code. There is a good chance that we have a person's name, but not their
address, so a PAXID, Last Name and First Name exist, but there would be no
entry in the ADDRESS sheet.

Is there an "easy" way to consolidate this kind of data?

John Jost
St. Louis MO

Combining Non-numerica data from multiple sources
 

Based on your question I would recomend a VLookup function. The general
format is to look up a value from within a list, returning an item from that
list, It also give you the option to specify an exact match or not.

=Vlookup(A1, Addresses, 3, false)

A1 is a specific PAXID
Addresses is a named range of Cells (You could just specify a range of
cells, but make sure that you specify the range in absolute terms)
3 specifies the third column in the list you are looking into
false means that you anly want exact matches returned.

If I was doing it my final formula would probably look like this

=if(isna(vlookup(A1, Addresses, 3, false)), "", vlookup(A1, Addresses, 3,
false))

If you have trouble just reply back...

"John Jost" wrote:

I need to consolidate data (non numerical data) together. In Sheet #1
(NAMES) I have three columns. The first is a unique key "PAXID" followed by
"Last Name" and "First Name". On Sheet #2 (ADDRESSES) I have the same
"PAXID" column followed by "Address Line 1", "Address Line 2", City",
"State", and "Postal Code"

I need to join all these fields into a single sheet that would have PAXID,
Last Name, First Name, AddressLine1, AddressLine2, City, State and Postal
Code. There is a good chance that we have a person's name, but not their
address, so a PAXID, Last Name and First Name exist, but there would be no
entry in the ADDRESS sheet.

Is there an "easy" way to consolidate this kind of data?

John Jost
St. Louis MO

Combining Non-numerica data from multiple sources
 

Hey Jim, Thanks I'll give that a try.

"Jim Thomlinson" wrote:

Based on your question I would recomend a VLookup function. The general
format is to look up a value from within a list, returning an item from that
list, It also give you the option to specify an exact match or not.

=Vlookup(A1, Addresses, 3, false)

A1 is a specific PAXID
Addresses is a named range of Cells (You could just specify a range of
cells, but make sure that you specify the range in absolute terms)
3 specifies the third column in the list you are looking into
false means that you anly want exact matches returned.

If I was doing it my final formula would probably look like this

=if(isna(vlookup(A1, Addresses, 3, false)), "", vlookup(A1, Addresses, 3,
false))

If you have trouble just reply back...

"John Jost" wrote:

I need to consolidate data (non numerical data) together. In Sheet #1
(NAMES) I have three columns. The first is a unique key "PAXID" followed by
"Last Name" and "First Name". On Sheet #2 (ADDRESSES) I have the same
"PAXID" column followed by "Address Line 1", "Address Line 2", City",
"State", and "Postal Code"

I need to join all these fields into a single sheet that would have PAXID,
Last Name, First Name, AddressLine1, AddressLine2, City, State and Postal
Code. There is a good chance that we have a person's name, but not their
address, so a PAXID, Last Name and First Name exist, but there would be no
entry in the ADDRESS sheet.

Is there an "easy" way to consolidate this kind of data?

John Jost
St. Louis MO