getCalculatedValue with Table in excel 2010

Jul 28, 2013 at 8:16 AM
Edited Jul 28, 2013 at 8:16 AM
Hi all,

I have a problem.
My calculation in excel is:
=IFERROR(VLOOKUP([@ID],Table15[[QUEST ID]:[Reward '#3]],$G$11,FALSE),"card:71003")
Calculation can calculate in excel but can not get in PHPExcel, because this calculation has some of character like "[" "]" ","
.Show that, it shows error:
Exception 'PHPExcel_Calculation_Exception' with message 'Quest_daily!AI14 -> Formula Error: An unexpected error occured' in C:\xampp\htdocs\quest\PHPExcel\Cell.php:298 Stack trace: #0 C:\xampp\htdocs\quest\demo3.php(355): PHPExcel_Cell->getCalculatedValue() #1 C:\xampp\htdocs\quest\demo3.php(266): getCellValue(Object(PHPExcel_Worksheet), 34, 14) #2 {main}
Can anyone help me to solve this problem?

Thanks all