Vlookup Function

[Christopher Naveen]

Hi,

Pls refer the vlookup formula mentioned below,

Cell : A2,
=VLOOKUP(A1,'[Jan''08.xls]Sheet1'!$B:$D,3,0)

I am entering the vlookup function in cell A2 and here i want to do multiple
functions. Ex : 1st this formula will execute and return a value and if it
returns #n/a it shud automatically look for the different table with
different vlookup function.

I tried with if condition and it returns a circular reference error.

Is it possible to execute the multiple function? If yes i request any one of
ur help.

Thanks in advance!

-Christ.

 

[Max]

One way is to nest it, indicatively like this:
=IF(ISNA(VLOOK1),IF(ISNA(VLOOK2),"",VLOOK2),VLOOK1)
The sequence structured is important if the lookup value could be found in
multiple lookup tables. If there's no possibility of this happening, then it
doesn't matter.

 

[Christopher Naveen]

Hi,

Thanks for ur immediate response and it is working fine. Also i have 1 more
query. 1st vlookup will look for #n/a and if it is true it will check for 2nd
vlookup but here inbetween i want to check 1 more condition.

After the execution of the 1st Vlookup if the result is "India" then reject
this result and go for 2nd vlookup. I have few countries in the lookup master
table and i need to reject particularly "india" and lookup for the 2nd
vlookup. I hope u understood my query. Can u pls help me on this.

Looking forward for ur response. Thanks a bunch.

-Christ

One way is to nest it, indicatively like this:
=IF(ISNA(VLOOK1),IF(ISNA(VLOOK2),"",VLOOK2),VLOOK1)
The sequence structured is important if the lookup value could be found in
multiple lookup tables. If there's no possibility of this happening, then it
doesn't matter.

---

Hi,

Pls refer the vlookup formula mentioned below,

Cell : A2,
=VLOOKUP(A1,'[Jan''08.xls]Sheet1'!$B:$D,3,0)

I am entering the vlookup function in cell A2 and here i want to do
multiple
functions. Ex : 1st this formula will execute and return a value and if it
returns #n/a it shud automatically look for the different table with
different vlookup function.

I tried with if condition and it returns a circular reference error.

Is it possible to execute the multiple function? If yes i request any one
of
ur help.

Thanks in advance!

-Christ.

 

[Max]

Indicatively, think you could try something like this (all in 1 cell):
=
IF(OR(ISNA(VLOOK1),VLOOK1="India"),
IF(OR(ISNA(VLOOK2),VLOOK2="India"),"",
VLOOK2),VLOOK1)