rajeshgajipara
New Member
- Joined
- Jun 19, 2008
- Messages
- 1
Hi,
I am getting #VALUE Error when i used VLOOKUP function in EXCEL.
I Excel sheet from java application using jxls.
after generating excel sheet by java, i open sheet in excel and i get #VALUE! error
i want values in J column. values are based on condition.
if H column's date matches in range A21:A500 then it returns value from BX (where X is match row no.)
J column shows #VALUE Error.
If i press F2- Save then it shows currect value.
Note: I used excel sheet as a template which contains VLOOKUP function and etc. upto row no.20.
From row no. 21 onwords my data comes from database.
When i write data in excel template and then save and then open, it gives #VALUE! Error.
Plese suggest solution.
File have been attched with thread.
I am getting #VALUE Error when i used VLOOKUP function in EXCEL.
I Excel sheet from java application using jxls.
after generating excel sheet by java, i open sheet in excel and i get #VALUE! error
i want values in J column. values are based on condition.
if H column's date matches in range A21:A500 then it returns value from BX (where X is match row no.)
J column shows #VALUE Error.
If i press F2- Save then it shows currect value.
Note: I used excel sheet as a template which contains VLOOKUP function and etc. upto row no.20.
From row no. 21 onwords my data comes from database.
When i write data in excel template and then save and then open, it gives #VALUE! Error.
Plese suggest solution.
File have been attched with thread.
Last edited:
