I am using LOOKUP and VLOOKUP to lookup data on tables.  I have done this
successfully, but I get unusual results when looking up calculated values.  
Sometimes the lookup results are correct sometimes not.  All values are
numbers, lookup_vector is in descending order.  Lookup ...

In columns A & B, I have a list of dates and values, such as:
1/1/1998     12.7
3/10/1998    10.4
7/24/1998    14.6

Been at it for a while... still trying to figure it out :confused:
All fields marked * are to be modified, while those marked otherwise
are static
I am working on a duty roster table that looks like this:

I would like to know if there's a command and/or keyboard shortcut tha
when you use it on a selected cell, it would tell you whic
formulas/cells refer to the selected cell.  I was also wondering i
there was a keyboard command that lets you change the sheet you

Hi, I am fairly new to both excelling, but have been lurking here for a
while.  I have used the search to find some good info about how to do
some if/then functions and the checkmark application.  My next issue is
I would like the colors of the cells to change color if they have a

Can someone help me shorten this formula? I'm not sure if the
mathamatics can be shortened by altering the formula or using a
different formula to figure out the problem, but the path name makes it
exceed the max amount of charachters. Changing the linking files path

I am pretty good with excell, but I am having trouble creating a few items.  
I would like to know if it is possible to create a formula that is linked to
cells on multiple sheets within the same workbook.  I understand you can do
several simile formulas from sheet to sheet or ...

I'd have a pivot table that contains 10 customer names. At any time,
different customers make up the Top5 revenue earners.  I'd like the pivot
table to show me the top 5 based on revenue (which I can make it do), and
then I'd like to see an OTHER line that groups all the others ...

I am making this little game and I need this functionality:
1.

_______ 4 ____________ 4

Sorry for the re-post, subject line was wrong.
In columns A & B, I have a list of dates and values, such as:
1/1/1998     12.7
3/10/1998    10.4

Hi everyone,
Completely new here. Trying to create an order form for my office. I
have worked on this problem for two days now, trying everything.
I have about three hundred items with a selection of prices. And I have

I have a worksheet with a list of results, such as...
Michael                            Tom                                Sue    
                         etc
Num1   Num2    Results     Num1   Num2    Results     Num1   Num2    Results

I have a set of raw data that's huge.  4 columns are relevant for m
question:  Quantity, Category, Style, Size.  I need a formula tha
tells me the following:
Look for Category X and Style Y and Size Z.  Give the sum of al

I am looking up everything in a column that has a "1" in it,(meaning there is
something due this week), and listing it's corrisponding value in a list of
items. Problum, if there is more then one thing due that week it only lists
one and not the others. Any suggestions?

I am trying to write a conditional format to check a line of text.  I have
=IF(COUNTIF(A4,"*docs\budget*")<>1)
to check if the words docs\budget are in a line of text and this is not
working.