I am trying to use the lookup function to find a value from another sheet.
The first one works but if there are muliple values that match then I cannot
get each one.
EX:

Does anyone know how to do a double "lookup" in Excel?
My situation is like this, I want to search a specific data on Column A
(under count), then after it's found I want to search the corresponding
matrix data for that item from the headers of Columns B to E. Then the result

When I select the worksheet to be moved and to the Edit menu and click- Move
or Copy Sheet- the workbook to which I want to move the worksheet doesn't
appear in the To BOX , eventhough I have the receiving workbook open.  What
must I do to have the new workbook listed in the TO ...

Cells C2:C13 has the Months Jan thru Dec. Cells D1:AJ1 has the years 2006
thru 2038. When I enter a value (ie 21.9) in cell F9 (Corresponding to Aug
2008) , I would like cell C8 to change back to white from blue and cell C9 to
change to green from white. When I enter a value (ie ...

I have a table of numbers, some positive, some negative.  Is there a way so
remove the "negativity" and change the number to a positive??  Would like to
do without altering the table of numbers or adding extra formulas.
Got me puzzled..

Hi Here’s a challenge for some one what I would like to do is, in cell A2 I
would like to click on it with the mouse and a tick goes in the cell which
would also subtract C2 from B2, with the answer in D2 and I would like B2 to
be a drop down box with 00:00 to 24:00 as time. And ...

I am trying to have the "Inch" symbol automatically inserted into a cell when
I type in a number.  For example, if I type a 12 in a cell, the Inch (")
symbol will automatically appear in front of that number.  Please advise

I have a medium sized spreadsheet (12 col, 3000 rows) and I have activated
the autofilters across the 12 columns.  The sheet is pre-sorted by the first
col which contains text and no filters are set.  In seeking a number in the
third column I use the drop list expecting to find a ...

When I start EXCEL I get a message box that says "This workbook is currently
referenced by another workbook and cannot be closed".  I have never
(intentionally) created such a reference and if I did I cant find it.  How do
I eliminate this message?  

i keep getting this error, can anyone tell me how to get rid of it ?

Our Excel spreadsheet (Excel 2002 SP3) keeps duplicating drawn lines
everytime we open and close the spreadsheet, making the spreadsheet grow 25%
in size. The lines have grown in number -- to 23,000 lines. The lines are
imbedded in iinformation and formatting that we do not want ...

I am trying to use an hlookup using the date as the lookup-value. In the case
that it finds a zero for that entry, I would like it to lookup the previous
entries until it finds a value. I have tried using TRUE in the logical range
lookup, but since all dates appear it still ...

I have a worksheet with an array of scheduled delivery dates, amounts, etc.
On another worksheet, I have a summary where there is a vlookup for the
delivery date. The problem is that if it is not on the same day, it will
return the last date rather than the next date. Can excel ...

I store alot of excel spreadsheets in a directory.  The spreadsheets contain
numbers.  When I search the directory for a specific number it does not find
it.   It will only find words.   Is there a trick to get it to find numbers.
Thanks,

There is an option in excel that seems to randomly work and not work. What I
have to do is type large numbers into excel cells and I can't possibly
remember the entire number so I will click on the cell to type a few of them
then click back on the internet to get more of the ...