Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Valliappan
1355
Error in using VLOOKUP in Excel
posted

Hi,

 we r using infragistics excel library for importing data from excel to the ultragrid. When we use VLOOKUP functionality in the cell

 (IFERROR(VLOOKUP(H4,Sheet1!B3:D43,3,),0) 

it fails with "#NAME?".  i have seen other posts where ppl reported the same issue. am assuming this is a bug. Can u plz let me know when can we get this fixed.?

1 other question , can excel library support VLOOKUP by referencing to a different workbook?

Thanks,

Valliappan 


  • 44743
    posted

    What version of the Excel library are you using? That looks like an error that has been fixed already.

    Currently, the Excel library does not support getting values from external workbooks, but external workbook data is cached with the workbooks that use them. So the Excel library will read and use this cached data when solving formulas. Therefore, you can use VLOOKUP functions referencing different workbooks, but it will only have the data from the last time the workbook was saved in Microsoft Excel.