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.