It looks like Yr_0405 and Yr_0506 are 2 dimensional arrays since you're
using them in VLOOKUP and specifying the column_index_number of 2. You're
also referencing these same named ranges in MATCH but MATCH can only work on
a one dimensional array as the lookup_array.

Try it like this:

=IF(COUNTIF(INDEX(Yr_0405,,1),A2),VLOOKUP(A2,Yr_04 05,2,0),IF(COUNTIF(INDEX(Yr_0506,,1),A2),VLOOKUP(A 2,Yr_0506,2,0),""))

--
Biff
Microsoft Excel MVP


"Montu" wrote in message
...
I have made a year wise data base in different sheets like
A B C
D E
1 Months Bill Amount Received Amount Due / Advance
Remark
2 Apr'04 45,342.50 32,248.00 13,094.50
Due
3 May'04 62,428.00 68,685.00 6,257.00
Advance
to be continue.... end of month
I have made also a report sheet to see details report (bill amount,
receive
amount, etc) of a period (as per choise) by puting moth & year in cell A2.
So
I have used a formula in B2 as below :-
=if(match(a2,Yr_0405,0),vlookup(a2,Yr_0405,2,0),if (match(a2,Yr_0506,0),vlookup(a2,Yr_0506,2,0),""))
Result show "#N/A,
Note = Yr_0405 is refrernce of Year 0405 data base
Yr_0506 is reference of Year 0506 data base
what should I do to see the report, help me.