=IF(B10="TWILL SHIRT",M2,0)
B10 IS A DROP DOWN LIST. I WOULD LIKE TO HAVE THE TRUE RETURN BE DIFFERENT
DROP DOWN LISTS CORRESPONDING TO EACH ITEM IN B10.

Does anyone know a way to use a referenced cell (containing text) and
have the parent cell use that text in the formula?
As an example.
In A1 I have "B1+B2" (stored as text, not an equation)

I hope you can help it will save a week of copy and paste.  In column A I
have a list of account names.  Lets say ABCDEFG, but there are 1000 names.  
In column B I have a list of products, lets call them 1-2-3-4-5-6.  I need to
create a two column list that combines the data so ...

I have a single list of values (we'll call it A:A) that I need to find
where they exist in another worksheet (Sheet2A:IV).
Obviously, if I do a Vlookup (or Hlookup), it'll only look in row A on
Sheet2 for my specified value.  Is there a formula that will look in

Hello -  I'm working on a massive payroll analysis.  I'm wondering if it's
possible to nest a networdays inside of an if function.  I pasted a formula
below that I'm using for the IF portion.  I'd like to replace the H5-H4
portion (which represent the start and stop dates) with ...

I have looked and cant find this question anywhere.  Lets say I have 49
employees who over 4 days have worked 1,572 hours and 19 minutes.  How
do I enter the 1,572 hrs and 19 min in Excel?  Once I can do that, then
I believe I multiply x 24 to get a whole number - correct?

My =Datedif("1999/12/1","2005/12/1","Y") function only returns 0's in the
cell what could be the problem?  
Cell is formatted for numbers.

What is the total revenue function for Excel?

I checked previous posts and found, what I thought was, an answer to my
problem with conditional formatting based on nested IF's.  No Joy,  I'm still
doing something wrong.  Help?
In cell I69 is a percentage of achieved sales.

Is there any way to 'evaluate' a dotted number (similar to an IPv4
address but not just those) using standard worksheet formulae (ie no
UDFs, VBA, or ATP functions)?
To make it a little more complicated, I need to be able to evaluate

This one's got me stumped so any help would be appreciated.  
Here's the problem, I've got one column with names in it and a second
column with dates in it. What I'm trying to do is generate a count in a
third column next to each name with the number of times the name appears

Hello, I have a schedule that I need to sort by size. I need a formula
in the results field to return the values that I manually entered.
Each day is looking at the previous to see what the last size was and
determine the closest size to start with, then sort in ascending or

I have an excel spreadsheet with contact info that I am importing into
outlook. Right now, my address' are in 3 columns (number, street,
designator). How can I combine the 3 columns into 1 column so that the
address is all together?

I'm trying to create a workbook that uses a list to record each report.  A
separate worksheet (called report) would serve as the report template.  
Each variable cell on the report would refer to a given column on the list
worksheet. The trick is to select the current row of the ...

if i have a column for student's name and other for their grades. how can i
find using functions the name of student who have the highest grade