Multiple v-lookups

[MN_Excel]

I'm attempting to use multiple v-lookups in one formula. If the item is not found in the first v-lookup, I would like it to search the second v-lookup for the value. If it appears in neither range I would like "none" to display. Not sure what I'm missing when I try this, but I can't get it to work.

Any ideas?

 

[T. Valko]

I'm attempting to use multiple v-lookups in one formula. If the item is not found in the first v-lookup, I would like it to search the second v-lookup for the value. If it appears in neither range I would like "none" to display. Not sure what I'm missing when I try this, but I can't get it to work.

Any ideas?

Even if the formula doesn't work post it so we can see what you're trying to do with it.

 

[cb12]

Perhaps something like this

=IFERROR(VLOOKUP(E1,A1:B6,2,0),IFERROR(VLOOKUP(E1,C1:D6,2,0),""))

Where the lookup value is in E1 and your two ranges are A1:B6 and C1:D6 - change as appropriate

 

[MN_Excel]

This looks great. Can I also add a third v-lookup?

 

[cb12]

Sure, just replace the IFERROR value with another vlookup.

eg:

=IFERROR(VLOOKUP(E1,A1:B6,2,0),IFERROR(VLOOKUP(E1,C1:D6,2,0),IFERROR(VLOOKUP(E1,A7:B12,2,0),"")))

 

[MN_Excel]

Thanks again