Hi- I am using vlookup where the lookup table is in another file, I
have the file name in a cell of the sheet, please let me know how to
refer to the file name and range name in the vlookup function by using
the cell address that contains the file name.

hi im workin on a college microsoft office 2003 class and i need to calculate
principal payed in one year on a five year note any help?

general question,
Windows XP Pro SP1, office 2000 excel 2000
1> when i have documents & programs open on the desktop, there corresponding
icons appear within the task bar, when the taskbar option of "Group Similar

I have a workbook that has several tabs.  I share this workbook with several
people and I'd like for each of them to have their own individual password to
their particular tab of the workbook to view their data, but I'd like to have
a master passord myself so that I don't have to ...

Debra Dalgleish <dsd@contexturesXSPAM.com> wrote in message news:<425E695F.6060205@contexturesXSPAM.com>...

Could anyone assist me in assessing what is wrong with the formula below. I
am getting a message "the formula you typed contains and error". What is
highlighted is the last AND shown below
Thanks

I have a user that wants to put a checkmark in a cell as a yes or no to each
record (row) that either has a contract or not.
I tried putting in the form field but that really doesn't seem to be it.
I tried to talk her into simply putting an X in the cell but she would

Can we print a selection (print area) twice on the same paper A4 size.
The first time on the uper half of the paper & the second time on the lower
half of the paper.
Khalil Handal

Got my template XLT and I don't want my user to save any Spreadsheet
based on it.
In the BeforeSave event : no problem. Save is disabled.
But in the BeforeClose event, I can't figure out how to do as if I set

I have many .xls files in one folder, they have different file names
but all of them have one worksheet called "Import", what I wish to do
is to make Excell import data from every .xls file in directory but
only the data which is placed in "Import" Sheet.

I have .NET code that uses Microsoft.Jet.OLEDB.4.0 to create Excel
worksheets of data. The end result is that we get an Excel Worksheet with
columns (both header and individual rows) that have alpha-numeric data
prefixed by a single quote (').

is there any interface (like Variables in MS Word) in Excel and
powerpoint. actually i want to store some hidden binary data through
VBA in PowerPoint and Excel. in word i have used document variable for
it. but now i have to do same in Excel and Powerpoint. Any Idea about.

Hi, I'm trying to create a dynamic form where I want to put 56
checkboxes, each one with one of the different "Excel colors" that
there are. With that I mean the 56 colors that you can set to for
instance a cell by using Interior.ColorIndex.

Excel doesn't seem to have a built in Xor operator or function, as far
as I can tell.  Is there any way to Xor two decimal numbers in Excel?
Thanks.
Steve

I want my formula to do the following:
If cell# =0 then "No Date", if cell# >=45 then Y otherwise N
So I write it like this
=IF((J46=0,"No Date"),IF(J46>=45,"Y","N"))