Sequential VLookups

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
"rng1" is a define name range A10:K10
"rng2"...................................O10:Y10
"rng3"...................................AA10:AK10

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

If it doesn't find in one of those three ranges, it returns #N/A
 
You need to combine with if statements;;;

if(isna(vlookup(a3,a10:k10,3,false)),if(isna(vlookup(a3,o10:y10,3,false)),vl
ookup(a3,aa10:ak10,3,false))
 
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
 
Back
Top