I'm trying figure out a way to use a vlookup function when the word in the
table is the same but indented differently.  For instance, you're looking for
the price of an 'apple' but the word 'apple' in the table is actually written
'     apple' with 4 spaces in front of the word.

Is it possible in Excel 2003 to make a cell with a formula, that has the
outcome zero, to appear as an empty cell? I am making a line graphic but I
want the cells with zero not added in the graphic. How is this possible?

I am using numbers for sheetnames and I need them in a cell in this way
=VALUE(RIGHT(CELL("filename";A3);2))
Is there any another way to put the sheetname into the cell?

Although i understand permutations i cant find  a quick and easy way to
multiply all the combinations for a permuation. Doing it long hand works but
is time consuming as i currently have 2 rows with a total of 165
combinations.

I have a constant range of cells D8:D31 (two periods per month) on each sheet
where I need to get the number of cells with data, and the number of blank
cells AFTER cells with data. (I don't want to include the empty cells before
the sales data starts). I need to do a projection ...

I am trying to get subtotals added to a trial balance report. The report has
the account numbers listed first and show a list of account numbers. With
each change in the first number the group change. How can I subtotal all the
cash, liability, revenue, expense............?

Please help.
I want to convert a date serial number into a long date text string so that
I caan incorporate in a concanenated statement. Whenever I use a cell wher i
think I have done this the value that appears in the concat statement is the

Ok, I have looked but can't find the answer I am looking for.
Background:  There was a pivot table created which is linked to either a
sheet in the same workbook or I have also linked it to an external datasource
which has the same dataset layout and fields.

Good afternoon - I have a order entry file I'm trying to enable the
possibility for offering quantity breaks.  However, the different items
to be sold have different levels of qty breaks.  For example:
Item   Qty  Price    Break1   Break1Price   Break2   Break2 Price

Im hoping someone can assist me in creating a formula that does the following.
I would like it to look at a cell, and that cell contains a number greater
that 120, to return a figure of 10 for each increment of 30 over 120.  For
instance, if the cell contained 121 it would return ...

I have a workbook with several sheets that has a pivot table per sheet. The
pivot tables access a sql database. The data is filtered on the period. The
filter is hardcoded into Microsoft query. All the pivot tables uses the same
filter, but very disparate data.

I have an Excel spreadsheet that was created by someone else, but is saved on
my computer.  Certain cells have always been shaded.  My computer was just
upgraded, although my Excel version is the same.  The shading is now gone
from this file (same file, transferred to the new ...

How do I calculate the distace between two GPS coordinates using Excel?

I have some dates like this:Sunday, 10 September 2006
in my worksheet, I've tried to change the format in excel with no luck.
If they can be changed would it be possible to run a macro to change all the
dates in the worksheet in one go.

Hi;
I am working in a company that we use cash balancing sheet at the end of the
day
in theory there is 200$ at morning, at the end of the day deposit all the