I'm trying to select a value from a table based on 2 variable references.
If been looking at using a VLOOKUP function to do this but because there are
2 dependant references I'm a little stuck.  I thought that maybe a VLOOKUP
with a MATCH function incorporated might be an option ...

Maybe someone here could provide guidance:
Have a column containing data which may have 1-3 dashes locates within
each cell value.
Such as:

I need to make a sheet that give totals based on monthly figures from
last year.
Then based on difference between the 2 it will show no increase and no
bonus, or it will show an increase and bonus based on increments $75.

hi, I've been playing with an if function i just cant figure out for
about close to an hour, i figure it will be much faster just asking
someone experienced.
I have three columns. A, B, C lets say

do you know how i can lookup value that isn't precise. for example if i
was using a vlookup function is there a way to lookup a value that isn't
exact, as if i was looking up "January" but wanted to include cells that
contain

I have three sheets in a workbook. The first sheet contains a project
plan from MS Project, the second sheet contains the same Project Plan,
except updated by Project Managers.
Here is where the fun begins. In the third sheet I'm trying to do a

I'm collecting business cards to enter contact information in MS Excel. I
will probably be collecting the same cards, month after month. Is there a way
that when I start entering data from a business card, Excel will know that
infomation is already entered so there won't be a ...

My data is imported from a seperate program and the other progra
automatically opens a new work book when the import starts. My problem
the data only resides on the first worksheet and then there are 2 to
blank worksheets. Is there any way to right a macro to delete only th

I'm stuck on a puzzling formula I'm creating for a client, and am i
desperate need of help.  
What I want to do (and have done) is set up 2 drop down menus.
My drop down menus are in column A, Row 1 and 2.

I am trying to calculate the %variance between MTD actual and MTD
target.  I can't seem to find it in my excel book or in the help
facility.  Any help would be appreciated.  Thank you! :)

i only want to copy & paste the subtotals, not the supporting data
thanks

At this point Excel hates me, I can feel it. So this is what my next issue
is. I have column B which the user places an "x" in the cell that corresponds
with a day of the week in column A. I have column C that has an "x" placed
into the cell when a certain code is inputed into ...

hi .can you please help
i have a formula for adding 3 weight
together. but i need excel to pick and add the 2 biggest together an
put answer in cell A7  B7 C7.

I am trying to use Excel to do my manpower allocation and planning. So I have
a column of employees and a row of months. I then put in the project name
that each is working on in a given month.
then at the bottom, I just sum the number of people working on a particular

Ok, I am so close to this worksheet being done. Thank you everyone for your
help and finally one last question, I hope :)
I have everything working the way I want it to work, now I want to protect
my workbook from the people who might use it deleting the funtions/formulas