Calculate for VLOOKUP doesn't work properly

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
jsfkcz
Posts: 29
Joined: Thu Sep 11, 2014 8:29 am

Calculate for VLOOKUP doesn't work properly

Post by jsfkcz »

Hello,
I have 2 formulas with VLOOKUP function in my "template" (it euqals czech function SVYHLEDAT):
The first one uses an address of lookup area and the second one uses a named range.
After writting new data, the second formula shows #N/A as wrong value, but after Ctr+Alt+F9 everything become OK.
Template
Image
Result
Image
(tested at 5.20.39 and 5.20.40)

The template and result are at http://www.genet.cz/kohout/xlsrw/xlsrw_vlookup.zip for download.

Josef Kohout
Last edited by jsfkcz on Thu Mar 19, 2015 1:55 pm, edited 1 time in total.
Top
jsfkcz
Posts: 29
Joined: Thu Sep 11, 2014 8:29 am

Re: Calculate for VLOOKUP doesn't work properly

Post by jsfkcz »

Please check VLOOKUP /calculate function - it still doesn't work under 5.20.44

Josef Kohout
Top
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Calculate for VLOOKUP doesn't work properly

Post by larsa »

Hello

This is fixed in update 5.20.45
Lars Arvidsson, Axolot Data
Top
Post Reply

Return to “XLSReadWritwII 6”