Jim, Would it be possible for you to take a look at this?
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=53969&p=235679 I just wrote a detailed explanation of my problem. Thank you for writing. Tony On Sat, May 19, 2012 at 6:45 PM, Jim Plante <[email protected]> wrote: > > Conversion factors for the two scenarios can be handled by a VLOOKUP(). > > Since I haven't seen your problem personally, I'm guessing at a solution. > Your file is no longer available. If this annoys you, just say so and I'll > leave you to it. > > I'd add a sheet to reflect the 1kg, 1.5kg, and 2kg prices beside the > countries. Let's call it "Weights" and structure it like this: > Country 1 1.5 2 > Brazil 10.25 15.00 20.00 > Russia 17.00 27.50 32.00 > > VLOOKUP (Weights.A1:Weights.A6 "=" Invoice.E21; Weights.A1:Weights.D6; 4; > FALSE) > > The first argument says to look up the word found in cell E21 on sheet > "Invoice" in the table found on Sheet "Weights" from cell A1 to cell A6. > The *last* argument, "FALSE", says this has to be an exact match. > > The second argument says to look on the "Weights" sheet from A1 to D6. The > third argument, the index, says to take the return value from column number > 4 of that array. (The first column is "1", not "0"). > > This would return 20.00 for Brazil, or 32.00 for Russia, since the answer > is to be found in column 4. You might want to use an HLOOKUP to set that > index. > > Jim Plante > > > On May 19, 2012, at 10:42 AM, Tony wrote: > > > On Sat, May 19, 2012 at 5:38 PM, Jim Plante <[email protected]> wrote: > > > >> Have you tried imbedding a Calc spreadsheet? > >> > > > > I'm sorry, I thought a scenario _was_ an embedded Calc spreadsheet? > > > > Tony > > > > > >> > >> Jim Plante > >> > >> On May 19, 2012, at 3:08 AM, Tony wrote: > >> > >>> Is there no way to put two scenarios (currencies and weights) inside > >>> another scenario (languages)? > >>> > >>> Thanks! > >>> > >>> Tony > >> > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [email protected] > >> For additional commands, e-mail: [email protected] > >> > >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
