Sequential VLookups
 

I have a spreadsheet that has three tables. I need to create a lookup that
looks in the first table and if it doesn't find the value goes to the second
table and then the third to find the value. What I have been using is

vlookup(a3,a10:k10,3,vlookup(a3,o10:y10,3,vlookup( a3,aa10:ak10,3,0)))

and it's not working. Any ideas.
--
Motaad

Sequential VLookups
 

"rng1" is a define name range A10:K10
"rng2"...................................O10:Y 10
"rng3"...................................AA10: AK10

=VLOOKUP(A3,IF(COUNTIF(rng1,A3),rng1,IF(COUNTIF(rn g2,A3),rng2,rng3)),3,0)

If it doesn't find in one of those three ranges, it returns #N/A


"Motaad" wrote:

I have a spreadsheet that has three tables. I need to create a lookup that
looks in the first table and if it doesn't find the value goes to the second
table and then the third to find the value. What I have been using is

vlookup(a3,a10:k10,3,vlookup(a3,o10:y10,3,vlookup( a3,aa10:ak10,3,0)))

and it's not working. Any ideas.
--
Motaad

Sequential VLookups
 

You need to combine with if statements;;;

if(isna(vlookup(a3,a10:k10,3,false)),if(isna(vlook up(a3,o10:y10,3,false)),vl
ookup(a3,aa10:ak10,3,false))


"Motaad" wrote in message
...
I have a spreadsheet that has three tables. I need to create a lookup
that
looks in the first table and if it doesn't find the value goes to the
second
table and then the third to find the value. What I have been using is

vlookup(a3,a10:k10,3,vlookup(a3,o10:y10,3,vlookup( a3,aa10:ak10,3,0)))

and it's not working. Any ideas.
--
Motaad

Sequential VLookups
 

If the ranges you supply are the real ranges, perhaps this would suffice.......

=IF(A3=A10,C10,IF(A3=O10,Q10,IF(A3=AA10,AC10,"NOT FOUND")))

Vaya con Dios,
Chuck, CABGx3



"Motaad" wrote:

I have a spreadsheet that has three tables. I need to create a lookup that
looks in the first table and if it doesn't find the value goes to the second
table and then the third to find the value. What I have been using is

vlookup(a3,a10:k10,3,vlookup(a3,o10:y10,3,vlookup( a3,aa10:ak10,3,0)))

and it's not working. Any ideas.
--
Motaad

Sequential VLookups
 

Thank you .... it worked...not sure why .... but it did :-)
--
Motaad


"Teethless mama" wrote:

"rng1" is a define name range A10:K10
"rng2"...................................O10:Y 10
"rng3"...................................AA10: AK10

=VLOOKUP(A3,IF(COUNTIF(rng1,A3),rng1,IF(COUNTIF(rn g2,A3),rng2,rng3)),3,0)

If it doesn't find in one of those three ranges, it returns #N/A


"Motaad" wrote:

I have a spreadsheet that has three tables. I need to create a lookup that
looks in the first table and if it doesn't find the value goes to the second
table and then the third to find the value. What I have been using is

vlookup(a3,a10:k10,3,vlookup(a3,o10:y10,3,vlookup( a3,aa10:ak10,3,0)))

and it's not working. Any ideas.
--
Motaad

Sequential VLookups
 

You're welcome!

"Motaad" wrote:

Thank you .... it worked...not sure why .... but it did :-)
--
Motaad


"Teethless mama" wrote:

"rng1" is a define name range A10:K10
"rng2"...................................O10:Y 10
"rng3"...................................AA10: AK10

=VLOOKUP(A3,IF(COUNTIF(rng1,A3),rng1,IF(COUNTIF(rn g2,A3),rng2,rng3)),3,0)

If it doesn't find in one of those three ranges, it returns #N/A


"Motaad" wrote:

I have a spreadsheet that has three tables. I need to create a lookup that
looks in the first table and if it doesn't find the value goes to the second
table and then the third to find the value. What I have been using is

vlookup(a3,a10:k10,3,vlookup(a3,o10:y10,3,vlookup( a3,aa10:ak10,3,0)))

and it's not working. Any ideas.
--
Motaad