Can you nest vlookups???

[teebruin]

I was wondering if you can do something like this with vlookups:

If the value in A1 is in the first lookup range, return the value in D1. If not in that range, then look A1 in the second range, and return the value in D1 of the second range. Else, return N/A.

Is this possible??

[Chris Davison]

On 2002-05-13 13:17, teebruin wrote:
I was wondering if you can do something like this with vlookups:

If the value in A1 is in the first lookup range, return the value in D1. If not in that range, then look A1 in the second range, and return the value in D1 of the second range. Else, return N/A.

Is this possible??

Just to clarify

if the value in A1 exists in your first lookup, do you want it to bring back the value IN CELL D1 or the respective value in the VLOOKUP range no matter where it is ?

ditto the second arguement....

[teebruin]

I want to look up the value in column A of my worksheet in a lookup table. If a match is found, I want to return the corresponding value from that lookup range. If the value is not found in the first lookup range, then I want to look the value up in a second lookup table, and the corresponding value returned if a match is found. I want the N/A error if the value can't be found in either of the 2 lookup tables.

[Asala42]

G'day,

I want to look up the value in column A of my worksheet in a lookup table. If a match is found, I want to return the corresponding value from that lookup range. If the value is not found in the first lookup range, then I want to look the value up in a second lookup table, and the corresponding value returned if a match is found. I want the N/A error if the value can't be found in either of the 2 lookup tables.

Yes you can nest multiple Vlookups and multiple IF statements - I believe excel spits the formula back after 7. You might also get away with a formula similar to this:

=IF(COUNTIF(Range1,A2)>0,Vlookup(A2,Range1,2,0),IF(COUNTIF(Range2,A2)>0,VLOOKUP(A2,Range2,2,0),""))

Hope that helps,
Adam

[Aladin Akyurek]

On 2002-05-13 13:28, teebruin wrote:
I want to look up the value in column A of my worksheet in a lookup table. If a match is found, I want to return the corresponding value from that lookup range. If the value is not found in the first lookup range, then I want to look the value up in a second lookup table, and the corresponding value returned if a match is found. I want the N/A error if the value can't be found in either of the 2 lookup tables.

Have a look at my contrib in the thread:

http://www.mrexcel.com/board/viewtop...c=7944&forum=2

which might be adapted to your situation.



[ This Message was edited by: Aladin Akyurek on 2002-05-13 13:36 ]

[teebruin]

Solution found.

Thanks Aladin for the thread; it was very helpful.

Using IF(ISNA(VLOOKUP1),VLOOKUP2,VLOOKUP1)
works just fine for my problem.