Using an Excel Sheet in a custom outlook form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I designed a form in Outlook 2003 and inserted an excel sheet 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 spreadsheet 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.
 
Sue,
Can you give me a link to the form where you used the lookup function in an
excel sheet.
The scenario is
There is an existing excel sheet. This sheet needs to be reproduced in an
outlook form along with all formulas and calculations. I inserted the sheet
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 spreadsheet.
I can possibly send you the spreadsheet and the form.
Any help that you can provide is highly appreciated.
 
I just added a simple Lookup() with source and results ranges to my form's
spreadsheet. 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
 
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 spreadsheet. I can send the spreadsheet and form if necessary.
Thanks,
Prem.
 
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 spreadsheet 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
 
Thanks Sue, I will try using the method you gave. The problem is in design
and runtime modes. Hopefully it should work.
Thanks,
Prem.
 
Back
Top