The MATCH function is returning either an index (if it matches) or NA. But
the condition in the IF function should be TRUE/FALSE. So enclose the match
in an ISNUMBER test:
=if(isnumber(match(a2,Yr_0405,0)),vlookup(a2,Yr_04 05,2,0),if(isnumber(match(a2,Yr_0506,0)),vlookup(a 2,Yr_0506,2,0),""))


"Montu" wrote:

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.