How do I create an If-then-else function in which If(certain value
equals either one of a specified list of 10 values
The issue is not how the if then else works, the issue is how t
compare with a list of several options (say 20 values)?

This is a two part question...
Here's what I have:
I have a list of product numbers in col. A.  In col. O I have a list of file
names that contain the product numbers as well as additional characters.  I

I have researched the posts and found only a partial solution:
I want to use a cell value to dynamically determine the print area,
I found the following:
define name Print_area and use the formula:

This is a request for a friend.  He has a long list on numbers (usually 10
digits) in a column.  Let's say A1:A300.  Is there a formula that will enter
all of those numbers into one cell consecutively separated by commas and no
spaces?  I guess the question also begs the question ...

I have a spreadsheet with thousands of invoice numbers, i need to identify
duplicate numbers within a specific column.  I'm not great with excel,
lay-terms would be appreciated =)

I want to format my spreadsheet so that when an if/then formula returns a
zero balance, the entire row is hidden or suppressed.  Can this be done in
Excel?

I am trying to perform a standard vector LOOKUP on some data I have.  The
problem I am facing is that my data array contains over 83 thousand lines and
Excel will only work with 65536 lines.  What am I supposed to do here?  I
need the LOOKUP to work to replace city and state ...

I have a large spreadsheet, and I am looking for a formula to help me find
some values...
My spreadsheet has about 5,000 rows and 200 columns.  I am looking for a
formula that will look up Large/Small values in column X, verify a condition

I have a formula in a cell(A) that reads the information from another cell(B)
using the Vlookup function.  However, some of these B cells contain a formula
with no results in them, resulting in A displaying the #VALUE! error.  is
there a way to ignore those cells that contain no ...

i am trying to round down the "true" result of an IF formula but can't figure
out how to nest the ROUNDDOWN formula within the IF formula.....can anyone
help?

Hi everyone. You guys are always a lot of help when I start hitting a wall!
Hope someone can help me again.
I am running XP Pro, SP2, and Office Professional 2003.
I am designing an invoice template for my company.

How do I pull a specific cost center number from column B to line up with an
account also in column B. For example I have a list of accounts followed by
the cost center that I need to tie to the account associated with the cost
center. The number of accounts and cost centers are ...

I have 2 "sets" of data in the same worksheet and would like to compare a 1
row by 2 column array in one data "set" to an n row X 2 column array in the
other data "set".  I don't care about the result other than identifying any 1
X 2 arrays not in the n X 2 array.

Hi all, I have a formula that looks at the cell value on one sheet an
adds it to the previous value on the original sheet, my problem i
this....where this formula appears it shows the last summed value so i
this case from S6 down to Sxxx it will show the value £813 because thi

I need to create a recognition for a column. for example. i have a list
of dates starting from May 1, 2006 all the way to December 3, 2010.
and the dates repeat  as well.
example: