| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Proble with using match function
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Match as well as does not match array function | Excel Discussion (Misc queries) | |||
| Hlookup or Vlookup problem? or wich other solution? Complex Proble | Excel Discussion (Misc queries) | |||
| Import/Export Proble. Urgent | Excel Discussion (Misc queries) | |||
Threaded Mode
