Re: Using an Excel *** in a custom outlook form

From: Sue Mosher [MVP-Outlook] (suemvp_at_outlookcode.com)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 13:55:47 -0500

So, you're using the array format for that formula. I can't duplicate the
problem in Outlook 2003. Are you seeing the problem in design mode or at
runtime or both.

FYI, you can paste a formula into a spread*** control cell: Click in the
cell, so that you see the insertion point in the cell. Then, right-click the
cell and choose Advanced Properties. Select the Formula field, then
right-click in the blank box at the top of the dialog and choose Paste. 

-- 
Sue Mosher, Outlook MVP
Author of
     Microsoft Outlook Programming - Jumpstart for
     Administrators, Power Users, and Developers
     http://www.outlookcode.com/jumpstart.aspx
"Prem Iyangar" <PremIyangar@discussions.microsoft.com> wrote in message 
news:F3A9D8B2-2740-4684-9574-3AA68BA554D7@microsoft.com...
> The exact lookup formula is
> =LOOKUP((B9-(($B6+$B8)/2))/(((($B8/$B6)-1)/((($B8/$B6)*1.282)+1.282))*
> (($B8+$B6)/2)),{-10,-1.282,-0.842,-0.524,-0.253,0,0.253,0.524,0.842,1.282;1,2,3,4,5,6,7,8,9,10})
>
> All cells referenced in the formula are general numbers. The formula works
> fine in a spread***. I can send the spread*** and form if necessary.
> Thanks,
> Prem.
>
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> I just added a simple Lookup() with source and results ranges to my 
>> form's
>> spread***. Please provide exact details of the Lookup() formula that
>> you're using.
>>
>> "Prem Iyangar" <PremIyangar@discussions.microsoft.com> wrote in message
>> news:B677CB53-483D-4ED2-8301-0EF8C99A3C3C@microsoft.com...
>> > Sue,
>> > Can you give me a link to the form where you used the lookup function 
>> > in
>> > an
>> > excel ***.
>> > The scenario is
>> > There is an existing excel ***. This *** needs to be reproduced in 
>> > an
>> > outlook form along with all formulas and calculations. I inserted the
>> > ***
>> > in an outlook form. I could not copy and paste the formulas, I had to
>> > re-enter the formulas in the form. All the formulas that I entered 
>> > worked
>> > except the Lookup function.
>> > Any lookup function that i enter in the cell does not work, even if the
>> > function has nothing to do with the spread***.
>> > I can possibly send you the spread*** and the form.
>> > Any help that you can provide is highly appreciated.
>> >
>> > "Sue Mosher [MVP-Outlook]" wrote:
>> >
>> >> Lookup worked for me in a small test here. Can you provide exact steps 
>> >> to
>> >> reproduce the problem?
>> >>
>> >> "Prem Iyangar" <PremIyangar@discussions.microsoft.com> wrote in 
>> >> message
>> >> news:6562B1E2-3E20-4339-9451-6E2C8BF3305F@microsoft.com...
>> >> >I designed a form in Outlook 2003 and inserted an excel *** in it 
>> >> >with
>> >> >a
>> >> > bunch of formulas in it. Everything works fine except for a LOOKUP
>> >> > function.
>> >> > The same lookup function works in an excel spread*** outside the
>> >> > form,
>> >> > but
>> >> > does not work in the form. It gives an error that says the formula 
>> >> > you
>> >> > types
>> >> > contains an error.