I am using this formula in one spreadsheet to sum several columns in a
different spreadsheet (06SO_LOG.xls) tab (MAR). I call this formula
for each month of the year. I also have the months as column labels
and would like the formula below to reference the month label so I

Hi to everyone,
I have a document with a table with various columns, and i would need to
search a column which is not the first, to return the corresponding value of
the first column. It would be fine to use vlookup if the column I´m searching

This may be a little confusing...to a beginner, me.
Instead of entering data in two worksheets can I:
In worksheet A
a1        b1           c1            d1

I am using the following function to create some sequential numbering:
=TEXT(ROW(A1), "W2-0000")
The problem I am having is when I try to change the W2 to H (or some other
letters) the formula no longer works and I get #VALUE!.

I have a column of texts. Some of cells are repeated. I want to obtain
unique column of texts. How can I obtain it.
Data I have:
aaa

I want to yield in the 1st cell "William" when I choose "Grocery" in another
cell and "MT" in the other. And 2nd cell "Ronald" when I choose "D&F" in
another cell and "RM" in the other.
How do I write the IF and AND function for the situation mentioned above?

Why does this not work: =IF(AND(B5="122"),(SUM(D5:L5)>1)),1,0

XP XP P XP P XP P P P XP XA XP XP
     XA XA P P P P P P XA XA XA XA XA
     XP XP P XP P XP P P P XP XP XP XP
     P XA P P P P P P XA UXA P P XA

I have a column of numbers that if the cell is a color and another cell is
"Y" then sum the color cells.
Below is my example and below that is an equation I tried, but it did not
work because the ColorIndex(), appears to not traverse through the Array it

Need to determine column of the lookup value in a table.
Lookup value = 6/1/06
Table     A             B           C
row 1   7/1/05    7/1/06    7/1/07

I am trying to predict future values using 2 data sets.  I'm not sure if
Forecast is the right function or if something else is better suited for
this.  My situation could best be illustrated using this simplified example.
I have 2006 data for weeks 1 thru 6.  I'm trying to ...

I observed that after I run the following "print" macro (with some rows
hidden):
________________
Sub Print()

How could I keep my cursor in 1 cell even after pressing the enter key? I key
data for vlookup and have to move the cursor back to the entry cell each
time.  It's a pain.  Any help will be appreciated.  Thx, Greg

I do not understand the use of 'Switch' at the place of the logical test ...

Is there a way I can do this?
I have a spreadsheet with a list of branches in cells A1 - A300.  I then
have columns of data for each of the past 5 years (ie; B - F) and want to
count the number of instances where particular items occur in each column