poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From abcdefghij <united_zel...@hotmail.com>
Subject Re: Apache POI excel function VLOOKUP
Date Fri, 04 Jun 2010 13:03:42 GMT

when i replace the validation list, the following formula needs to be
evaluated:

=VLOOKUP(A2;OFFSET('04-BEREIK'!$A$2;0;0;COUNTA('04-BEREIK'!$A:$A)-1;3);3;FALSE)

But the evaluation always result to 0...

Can anyone help with this?

kind regards
-- 
View this message in context: http://old.nabble.com/Apache-POI-excel-function-VLOOKUP-tp28779554p28779684.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message