I'm trying to do a vlookup with 2 sets of criteria.  For example:  I want to
look up a customer name in column A and the customer state in column D, if
they both match then bring back the # of employees per state in column F.

How do I get autofilter to ignore rows when selecting from the drop down list.
Here is my delima - I have notes at the bottom of my spreadsheet that I want
to always show no matter what selection is made with the filter.  Can I do
this, and if so how?

Hello and thank you for your time...Here is my question. I have created an
audit for my employees performance using a rating system, (i.e. Meets
expectations, Exceeds expectations, etc) in one worksheet of Excel 2002. I
have created a drop down list for each of the ratings and a ...

Is it possible to have a cell with a formula and still include text.  It is
easy enough to generate a calendar, (basically I'm creating the calendar by
dragging a date to other cells) but once I have the calendar, I want to be
able to insert text into the individual cells.  For ...

How can I protect a worksheet in a way that the user can use the checkboxes I
have made but can't delete them?
I have now tried to use the protection function with leaving certain cells
that I want available for user, but this disables the checkboxes. I can't

Is there a way to protect a watermark in excel?

Worksheets("Cost Analysis").Activate
   Set UdRng = ActiveSheet.Range("F10:F38")
   UdRng.Formula = "=IF(AND(A10>0, H10>0),"EQ","")"  << occuring here
   ActiveSheet.Range("A9:G38").Select

I have a client with a list of numbers, all 15 digits long, in one column.  
All cells are formatted as numeric "General".  All cells display all 15
digits, except one.  This one cell displays the number in scientific
notation, even though the cell appears to be formatted as ...

In Excel 2007, one of our users noticed a small, black arrow on the filter
button in her spreadsheet.  It appears to the right of the filter or standard
arrow on the button and it's a skinny black arrow pointing up.  What is this
and what does it mean/do?

Is there a way to protect the header and footer in an excel file?
I have the sheet protected but it still allows you to change the footer that
I currently have.

I'm using the following formula to lookup up my employees based on their ID#
and return the value in column 2 where a match is found. How do I sum up
these matches if the employee number appears more than once?
=VLOOKUP(X2,'LaborDetail'!P2:Q1000,2,FALSE)

I have an excel 2003 File (Workbook) with several worksheets.  Some info in
the worksheet that I want to preserve is derived from the other worksheets.  
I want to retain the actual values in the main worksheet and delete the other
worksheets.  Is there a way of doing this without ...

When I sort the fon I miss the vincles. If yo can answer me in Spanish that
better

How do I merge an excel spreadsheet into a Word document when it includes
cells that are formatted as text or preceeded by an apostrophe?

I need a formula that will subtract 10% of a number.