Re: Using an Excel Sheet in a custom outlook form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Prem Iyangar (PremIyangar_at_discussions.microsoft.com)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 06:05:07 -0800

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.
>
> --
> 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: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.
> >> > Any help is highly appreciated.
> >> > Thanks,
> >> > Prem.
> >>
> >>
> >>
>
>
>

Quantcast