it prints each column on a different page. Am I doing something wrong. I
would like all of the columns to be on the same page. (and it's not the width
of the column that's a problem)

I am trying to use lookup using a vector and array.  My lookup is in column
A500 thru A550.  I need to locate the information in Column D1 thru D800 and
return the result from Column F1 thru F800.  If nothing is found I need it
to return the result of 0. I havetried many times ...

Person A enters new or additional comments on Workbook 1. I have a VLOOKUP on
Workbook 2 that retrieves those comments but somethimes it displays just ###
signs. I have formatted the text to wrap. I have replaced the formula on book
2  with a new VLOOKUP formula in hopes of ...

Does anyone know how to combine dates and times that are in two different
columns into one column!?  I know that dates and times are really just a
series of numbers and when I use the CONCATENATE function it does add those
values together but I'm stumped as to how to get the ...

I have this in cell L9.
=INDEX(Sheet1!$F$36:$F$51,COLUMN()-11)
It works great when I drag across, transposing column data on another sheet
into a row.

I am trying to use the Match function in a database to find b-50's in column
a.  It does not find a match even though there is a cell that has that in it.
Is it because of the hypen?

I know how to calculate % change, but have run into a snag when the preceding
period had a negative value.
If last-period I had 5 and this period I have 10, I want 100%.  (No problem.)
Likewise, if last-period I had 10 and this period I have 5, I want -50%

Subj: Filling-in data based on adjacent cells.
I am using Microsoft Excel 2000. Here's my (autofill?) question...
I have data in some rows, others are vacant; e.g.,
          Col 1       Col 2        Col 3

Trying to sort a range of numbers and alphas (so formatted as TEXT),
but cannot seem to get it to work.  Any idea why it is not sorting the
entire range?

I am tryin gto create a formula but need to use more than 8 IF functions in
it. The program will not allow more but I need more, Can anyone suggest how I
may acheive this please
Thanks

Re:  =LOOKUP(2,1/A1:A100,A1:A100)
The following is my interpretation of this formula.  If I am wrong, please correct me.
I read that there is vector form and array form for LOOKUP.  This is vector form, right?  Since the purpose is to find the last value in the array, there is no ...

I started a subtotals calculation in a spreadsheet of about 8000 lines. The
calculation is taking a very long time. Can I successfully stop the
calculation, as I have figured a pivot table that can faster achieve my
query? How do I stop it?

I wish to be able to select "option button A" and have "area A" highlighted,
and "Area B" darkened. Then When I select "option Button B" have the reverse,
"Area A" darkened and "Area B" Highlighted.
Area A and Area B are groups of about 12 cells

Dear friends in the community,
I faced the problem of not able to open the Excel file after updating the
first version of MS Office 2007 Beta with the technical refresh.
What I think the most likely reason is that the technical refresh that I

     i have a document which is added with leading Zero's in some of the
columns
for eg., in the ZIPCODE column my value is 09281 but in the display i am
getting it