Can I use VLOOKUP to compare values in another table?  What would that
formula look like?  I've been going through various 'help' areas and cannot
find a sample of how that would look.
Thank you.

I am trying to use the IF function but it may be the wrong one.  Below is my
formula but it keeps coming up #VALUE!.  What am I doing wrong?  Any
assistance provided would be helpful.
=IF(H8=1,150),IF(H8=2,300),IF(H8=3,450),IF(H8=4,600),IF(H8=5,750),IF(H8=6,900),IF(H8=7,1015) ...

I am trying to use a template (blood sugar) and have two problems. I need
more columnsz but can't seem to format them the same. 2. I want to have a
cell with two devided cells under it as in first and last names only this
will be insulin dosage and 2 types of insulin. I can't ...

I have a list of projects by row and I need to sum the lines that have one
key word.  For example I have May jakdjfld, May a0934u0, May 2309u09, etc.  I
want to sum all the rows with the word May in it.
I greatly appreciate your help.

I have over 1,000 rows with 3 columns of non-unique numbers/letters (no two
rows are entirely the same).
4    790    54
4    794    93

how do i use between instead of greater than or less than , in if then else
statement

what's wrong with the formula which throws #value error?
the formula is in Sheet1
C1; =VLOOKUP(OR(RIGHT(A1,6),MID(A1,6,6)),sheet2!$A$1:$C$8,3,FALSE)
the contents of A1:B9 in sheet1 is

I have a spread sheet in excel 2003 that has formular in it that add various
cell values to gether and when i use the If function to test the cells i keep
getting wrong results
=IF(AC3>0,1,0) every result = 1 even though the value in the cell is zero

I have a table (see below) that I totaled the first column using the sum
feature. The sum forumula is Sum(B4:B15) which equals 888,834. I copied this
cell and pasted to the next to columns and as you can see they have the same
total number, but the formula in the cells are Sum(C4 ...

We have a new tiered commission plan and I am trying to make a sheet that
shows the marketing reps how much revenue they have to bring in the following
month to average the amount needed to stay in the same tier and another
formula to show how much they need to bring in the ...

I work as a consultant to school districts and in doing so I set up
enrollment projection models in excel workbooks.  I am in the process of
refining our models and reducing the work we do.  My current workbook
consists of about 350 worksheets of data (they normally are not this ...

In converting columns to rows, I am able to COPY and paste but cannot CUT and
paste.  Am I doing something wrong or is it not possible to do this?
Thank you.

Is there a way to add a month to a series of data that is not
contiguous?  Example:
Row 1        June 1, 2006
Row 5

I've got a problem using keyboard to select cells when editing some "
sticky" formula. By "sticky", I mean when the arrows don't move you out
of the cell you are editing.
I found this problem does not exist when starting a new formula, where

How do I make the cell flash on and off to draw it to the attention of my
students?