Dear sir,
I have one question regarding an "index" formular together with "match".   I
used to set the following excel function to pick the data from the database:
=INDEX("database",MATCH("column argument","column range",0),"target column

I have some VLOOKUPs which sometimes return 50 or 60 characters (they're in
merged cells). I want the text to wrap, and the cell to enlarge to fit the
text - Just like it does whan you type it in, but somehow, because it is
being returned from a formula it just displays the ...

Spreadsheet software

Trying to return a 1 or 2 by the color format on a cell.  So if A1 is yellow
format, then return a 1 otherwise a 2.  Possibilities please?

Folks,
I regularly use a SUMPRODUCT formula to derive totals from a large array of
transactional data. If I am looking to calculate the sales total for a
specific month, I generally use the following formula:

I have a question about variable ranges like A:A compared to fixed ranges
like A1:A18000.  I asked the question in another thread.  But I suspect it
got lost in the "noise".
I don't think my question is specific to SUMIFS.  But to illustrate....

I have a table with several columns and a varying number of rows of data.
Each row represents work performed by an employee.  One employee generally
has several rows of data: base on the amout of work performed.
Column one is the "Office" in which the employee works: we have 8 ...

Using Excel 2007
okay, so I'm wanting to SUMIF a range of data in a row if that data
exceeds the value the cell at the end of the range.  So say I have a
range from A1:A10 containg numbers and I want to sum them if those

i have a excel file. one cell i set the format is currency with 2 decimal
places.
so, if i type 1000.678, then in this cell, it should be show 1000.68. it is
ok and normal in this excel file.

Using Excel 2007 on Windows XP.  We have 3 worksheets with 10 pages each.
We want the total pages in the workbook.  For example, Page 1 of 30, Page 2
of 30, etc.  I tried grouping the 3 worksheets but that didn't give me the
result I want.  Can this even be done?  Most stuff can, ...

CONFUSED
I may be using a formula that is trying to add to many cells at one time,
yet I've found nothing really to highlight the addion error.  Long and short,
here is a formula I'm using and it appears the last cell is the one not

I know that we can hyperlink to URLs and even files on a computer,
etc., but is there a way to hyperlink as a navigation tool between
worksheets?
I have too many entries to do up scripts and buttons to do this, and

My data appears in column B in the following format.  It relates to
horseracing sires with the heading SIRE.
Could I create a macro that would parse the data as in the second example?
Ideally, as in the third example.  This would enable me to do an

I run Excel 2K
I have typed the following formulas in three consecutive cells.
=SUM('DRO BY SHIFT'!Z10:Z12)+BP10
=SUM('DRO BY SHIFT'!Z13:Z15)+BP11

I have three macros that are password protected.
Macro 1 is a macro that I run and asks for my password.
Macro 2 is a macro that someone else runs on a daily basis.
Macro 3 is a macro that someone else runs on a daily basis.