Re: Using VLOOKUP

[Elvis Willems <ew...@schaubroeck.be>]

Hey Lauren,

I have had this same problem. The only solution I've found so far is to
store my template with OpenOffice Calc instead of MS Excel, in which
case the values show correctly when opening in either program. Although
I have seen some mails fly by, that gave me the impression you could do
something with FormulaEvaluator, but because I was pressured for time I
didn't try it out yet.
If you can get it to work this way, though, feel free to share.
Also, you can search the mailing list archives for more info.

Regards,

Elvis Willems




On Tue, 2007-12-18 at 12:29 -0600, Lauren Riley wrote:

> I am writing an excel file out...it has two cells with formulas.  The first
> one uses Index/Match to lookup a value in a table.  The second cell needs
> to use the "looked up" value in a VLOOKUP call (as the first parameter) to
> another table.  When the spreadsheet is written out I get this error in the
> second cell, "A value used in the formula is of the wrong data type." And
> it says #VALUE in the field.  If I go to the second cell's function in the
> textfield, and hit enter, then the correct value displays.  So I know I
> have the right formula, but it's like it can't compute the second cell
> because it doesn't yet have the value from the first cell lookup.  Is there
> a way to get around this?
> 
> Thank you!
> 
> 
> __________________________________________
> The information contained in this message may be privileged and
> confidential and protected from disclosure. If you are not the intended
> recipient of this message, you are hereby notified that any dissemination,
> distribution, or copying of this communication is strictly prohibited. If
> you have received this communication in error, please notify us immediately
> by replying to the message, and please delete it from your computer.

 **** DISCLAIMER ****
 http://www.schaubroeck.be/maildisclaimer.htm