I am trying to create text and when selected from a drop down list a specific
$ amount is input in the adjacent cell dependent on which item was selected
from the drop down.

I would like to make a cell G37 come back with a number from checking  IF
J37=1 and K2=1 Then LOOKUP FUNCTION But if J38=1 and K2=1 then LOOKUP
different function. If J37=1 and K2=2 then LOOKUP different function IF J38=1
and K2=2 then LOOKUP different function.

Using formula - =if($f5>"0",f5-e5,"") returns no response.
trying to get the difference b etwwen 2 dates where "F" column is day
vehicle left and "E" column is day vehicle arrived.
Is my formula wrong?

I made a workbook detailing three different hospitals that i coordinate for.
i have one sheet for all the hospitals, and one sheet for each individual
hospital with just that hospitals info in it, this totals four sheets. My
goal is to put info into only the all inclusive ...

Back in 2004, Jeff Borden asked about using GetPivotData with variable
criteria output. Here's his original question: http://tinyurl.com/2saafw
I have exactly the same issue. Debra Dalgleish supplies a working
solution, which is great, but its complexity makes maintenance an

Someone help! I need to know how I would do this i want to creat a formula
so that when i type in High it will equal 4 or Medium equal 2 or low equal 1.
So for example:
= IF(4,High;2, Medium;1,Low=()) - This doesnt work What i want is to add

I have a list of names, each separated by a semi-colon and a space, which I
have pasted into a cell (eg G1 = First Last1; First Last2; First Last3; First
Last4; First Last5)
How do I split out the names into a column so that

I am using Excel 2007, and have a question about the getpivot function
I have a pivot table set up where there are three rows that contain
different values of levels, and then a fourth row which is just a sum of
customer (so sum of all levels).  See below for an example.

i am trying to create a filter for an invoice that has over 650 items on it,
but i only want it to print the items that i am using for each invoice and
not all the items listed

I have a sample of the spreadsheet that I am working with below, what I need
to do is put together a function or formula that will flag the column with
the highest ODM reading for each unit.  Any ideas on a way that I could do
that - once the row was flagged on could filter to ...

I'd like to see which keystroke combinations have already been used in Excel
2003 to figure out which are still free for assignment to new macros.
How can I list those pairs?
z.entropic

I have a model with dummy names presently. I need some way to change the
worksheet names when the user chnges them in some cells in a  seperate
worksheet. What i need is a link to the worksheet names to a cell in another
worksheet. and when this cell is edited the worksheet name ...

I have a pivot table which I am trying to create. I have grouped some parts
together and I am trying to get the grouped field to show on each line
instead of just once. The exaample below is what I am working with. I would
like the salesman field to appear on each line.

I am trying to copy a cell from one sheet to another and I use the = function
but it doesn't copy the same format ie: bold and under line etc.

I have a (long) filing list oin Excel and suddenly the above message shows
when I try to do a search. Was working fine before and other files are ok.
Does anyone know how to fix it please?