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.
