If E1 has the name you want to look up, try:

=IF(ISNA(VLOOKUP(E1,Rio,1,0)),VLOOKUP(E1,fall,2,0) ,VLOOKUP(E1,Rio,2,0))

You seem to contradict yourself in your request to return blank if the name
doesn't appear in either list as you also state you know the name will appear
in one or the either since the unique list was compiled from both lists. If
it is possible the name might not appear in either list, you could try:

=IF(ISNA(VLOOKUP(E1,Rio,1,0)),IF(ISNA(VLOOKUP(E1,f all,1,0)),"",VLOOKUP(E1,fall,2,0)),VLOOKUP(E1,Rio, 2,0))


"Jordan" wrote:

I have two sets of data, named "Rio" and "Fall". Both have the same fields
in them. Name, Address, Phone and Email. There is duplicate names within
the two sets of data. Each data set by itself, does not have duplicates. I
combined the two list of names and created a unique list.

What I would like to do is using the name in the unique list is to lookup in
first in "Rio", if there is any 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 in "Rio" is more up to
date, so I would preferr the information there. If 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 returning zero's.

Any help will be greatly appreciated.