search

unvell / ReoGrid

Fast and powerful .NET spreadsheet component, support data format, freeze, outline, formula calculation, chart, script execution and etc. Compatible with Excel 2007 (.xlsx) format and working on .NET 3.5 (or client profile), WPF and Android platform.
https://reogrid.net
MIT License
1.33k stars 395 forks source link

VLookup? #198

Open desarrollo03TR opened 5 years ago

desarrollo03TR commented 5 years ago

It there support for VLookup function? my xlsx document is not updating the cells with vlookup function.

jingwood commented 5 years ago

Yes VLOOKUP is supported, try uppercase letters VLOOKUP. https://reogrid.net/document/formula-functions/vlookup/

desarrollo03TR commented 5 years ago

Yes VLOOKUP is supported, try uppercase letters VLOOKUP. https://reogrid.net/document/formula-functions/vlookup/

Is It possible to do a VLOOKUP using source form another worksheet? I tried with "=VLOOKUP(A9,Balance!A4:G975,7,0)" but it is not working. It works only if the source data is in the same worksheet.