I have a list of product codes on a sheet in column A and a ranges of cells
containing text that has the product code in amongst  the text.  I want to
extract from that text the text that matches any product in the array in
column A.  I have tried using the find function as an ...

Is it possible to name worksheets based on a formula?
I want sheet1 to be renamed to be whatever is in sheet1!A1 for instance.

I have researched this forum and have most of my problem solved.  My
customer has two columns of data representing a client's birthday; A1
has the birth year formatted as yyyy.  A2 has the birth month and day
formatted as mm/dd.  Here's the problem, A2 is formatted as "General"

My company uses a fiscal calendar where the month ends on the 4th Friday of
every month except for the end of the quarters (March, June, Sep, and Dec)
which end on the 5th Friday. I have a column with various dates ranging from
01/01/06 through today and I'd like the fiscal ...

I am trying to develop a template for researchers to use to help them develop
project budgets.  I am having a problem with one particular formula and am
not clear if I need to use "lookup", "match" or "if", or some combination of
the the three, or something completely different.  ...

Can you please help me with the following.
I need to lookup up a value in the cell A1 of sheet 1 and return the
value in sheet 2 of the column next to the the column with a heading
matching the value of B2 in sheet 1.

I tried searching, but didn't find my solution so:
I have a series of formulas that operate on a list of cells, but the
list is variable. I thought to replace all references to the cell list
with indirect, but it appears to fail on an address list.

I am trying to come up with a formula that will look at a column for a word
or set of words, look at a 2nd column and give me a running total in
another column as long as none of the values in the 2nd column match.  For
example, use the following worksheet

I am currently trying to get a cell to recognize the amount of work completed
by employees on a certain day, automatically.  Each employee uses a monthly
log, and column A includes the day in M/DD format, whereas column G includes
the word "Completed" or "Deferred."  I have ...

I need to figure out a formula that returns a date, for exmaple I need to
determine the date 10  bussines days from now taking into account a
determined list holidays...can you help me out with this?..I have tried
networkdays but can't figure it out.....thanks for your help

Using excel 2003 Ihave two columns one with first name and one with last
name. In a third column I used the formula and got Lastname, first name,
however I cannot delete the first two columns and retain the combined column.
What have I done wrong? Help please.

I'm trying to generate an equation to calculate the total value of costs in
one column, if there status value in another column is equal to 100 (or it
could be a string value of "Confirmed" - the value 100 is arbitary).
So it's Consolidate the Values in Column A if the ...

How do I make a cell change to a certain colour, without affecting the
number that is already in it? I run a lottery Syndicate using a simple
workbook with 2 sheets in it. The first sheet keeps a historic record of
each weeks numbers as I key them in. The second sheet has all ...

In a worksheet, I have a list cell(A1) that contains the words "Bodily
Injury", "Property Damage", and "Other".  In the next cell(A2), I would need
a function that says:  if A1 contaisn the word "bodily Injury" then go to
"Bodily Injury list" (which is on another worksheet).  But ...

I read to post on how to put an OR function inside and IF function. I can't
get it to work when I try to put an OR function into my array-entered IF
function.
This is what I have now: