Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
This is a re-post from last night. I didnt have enough information on the
first post. I have two sets of data, named "Rio" and "Fall". Both have the same fields in them. Name, Address, Phone and Email. Each data set by itself, does not have duplicates, however when I combine the two lists there are duplicate names. I combined the two list of names only and created a unique list. What I would like to do is using the name in the unique list is to lookup the other information ie: address etc. First in "Rio", if there is a value/text, return it and stop. If there is not, I would like to lookup in "Fall" for the same info that was missing in "Rio". If it is not in either one I would like to return nothing. In otherwords, I know the name will be in one or the other as I created the unique list from the two. I also know that the data (address, phone and email) in "Rio" is more up to date, so I would preferr the information there. If it is not there then I'll take the info from fall otherwise nothing. I have tried using embedded if statements along with vlookup's and it's not working as well as it is returning zero's. Any help will be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
try
=if(iserror(vlookup(name,rio_range,2,0),vlookup(na me,fall_range,2,0),vlookup(name,rio_range,2,0)) changing the 2 to 3 or 4 for the Phone and Email and settin up the range definitions appropriately "Jordan" wrote: This is a re-post from last night. I didnt have enough information on the first post. I have two sets of data, named "Rio" and "Fall". Both have the same fields in them. Name, Address, Phone and Email. Each data set by itself, does not have duplicates, however when I combine the two lists there are duplicate names. I combined the two list of names only and created a unique list. What I would like to do is using the name in the unique list is to lookup the other information ie: address etc. First in "Rio", if there is a value/text, return it and stop. If there is not, I would like to lookup in "Fall" for the same info that was missing in "Rio". If it is not in either one I would like to return nothing. In otherwords, I know the name will be in one or the other as I created the unique list from the two. I also know that the data (address, phone and email) in "Rio" is more up to date, so I would preferr the information there. If it is not there then I'll take the info from fall otherwise nothing. I have tried using embedded if statements along with vlookup's and it's not working as well as it is returning zero's. Any help will be greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
=if(iserror(vlookup(*name value*,rio,1,0)),vlookup(*name value*,fall,1,0))
change the column # for address, phone, & email "Jordan" wrote: This is a re-post from last night. I didnt have enough information on the first post. I have two sets of data, named "Rio" and "Fall". Both have the same fields in them. Name, Address, Phone and Email. Each data set by itself, does not have duplicates, however when I combine the two lists there are duplicate names. I combined the two list of names only and created a unique list. What I would like to do is using the name in the unique list is to lookup the other information ie: address etc. First in "Rio", if there is a value/text, return it and stop. If there is not, I would like to lookup in "Fall" for the same info that was missing in "Rio". If it is not in either one I would like to return nothing. In otherwords, I know the name will be in one or the other as I created the unique list from the two. I also know that the data (address, phone and email) in "Rio" is more up to date, so I would preferr the information there. If it is not there then I'll take the info from fall otherwise nothing. I have tried using embedded if statements along with vlookup's and it's not working as well as it is returning zero's. Any help will be greatly appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
Scusa -
Little quick on the send button =if(iserror(vlookup(*name value*,rio,1,0)),vlookup(*name value*,fall,1,0),vlookup(*name value*,rio,1,0)) "Duke Carey" wrote: =if(iserror(vlookup(*name value*,rio,1,0)),vlookup(*name value*,fall,1,0)) change the column # for address, phone, & email "Jordan" wrote: This is a re-post from last night. I didnt have enough information on the first post. I have two sets of data, named "Rio" and "Fall". Both have the same fields in them. Name, Address, Phone and Email. Each data set by itself, does not have duplicates, however when I combine the two lists there are duplicate names. I combined the two list of names only and created a unique list. What I would like to do is using the name in the unique list is to lookup the other information ie: address etc. First in "Rio", if there is a value/text, return it and stop. If there is not, I would like to lookup in "Fall" for the same info that was missing in "Rio". If it is not in either one I would like to return nothing. In otherwords, I know the name will be in one or the other as I created the unique list from the two. I also know that the data (address, phone and email) in "Rio" is more up to date, so I would preferr the information there. If it is not there then I'll take the info from fall otherwise nothing. I have tried using embedded if statements along with vlookup's and it's not working as well as it is returning zero's. Any help will be greatly appreciated. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
Also, if using XL 2007, it is
=iferror(vlookup(*name value*,rio,1,0),vlookup(*name value*,fall,1,0)) "Duke Carey" wrote: =if(iserror(vlookup(*name value*,rio,1,0)),vlookup(*name value*,fall,1,0)) change the column # for address, phone, & email "Jordan" wrote: This is a re-post from last night. I didnt have enough information on the first post. I have two sets of data, named "Rio" and "Fall". Both have the same fields in them. Name, Address, Phone and Email. Each data set by itself, does not have duplicates, however when I combine the two lists there are duplicate names. I combined the two list of names only and created a unique list. What I would like to do is using the name in the unique list is to lookup the other information ie: address etc. First in "Rio", if there is a value/text, return it and stop. If there is not, I would like to lookup in "Fall" for the same info that was missing in "Rio". If it is not in either one I would like to return nothing. In otherwords, I know the name will be in one or the other as I created the unique list from the two. I also know that the data (address, phone and email) in "Rio" is more up to date, so I would preferr the information there. If it is not there then I'll take the info from fall otherwise nothing. I have tried using embedded if statements along with vlookup's and it's not working as well as it is returning zero's. Any help will be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Lookup/Double Lookup | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |