Formula used for LastMthCost is =vlookup(A2,LastMthCost!A2:B3,2,FALSE)
Instead of returning 1.5 but i got 2.5!!!!!  Please help
Worksheet: ThisMthCost
    A                        B

I have a large workbook that I am using vlookup in. It is returning #n/a wher
e there is no data to pull. I am trying to add another formula to pull a
range of numbers from the main sheet. It works fine as long as there are no
NA's in the data I am pulling from. I need to know ...

I have a column of numbers that have varied length some have 2 digits, some
have 3 and some 4 and some 6. I need to add a sting  0's to bring the length
of the string of all all the numbers to 6.
I am an excel newbie so any help would be great!

Hopefully I'm posting this in the right area.  What I have is a form that
will require the employee to input their start and ending time.  Since most
do not have a clue as to military time format, I was trying to see if there
was a way to either put the time in a pop-up or list.  ...

Dear all...
Is there a way of suming a column of data based firstly on a criteria
(E.g. Name = "Bob") and then on the relative order in which the values
appear in the list (E.g. Sum the 1st, 2nd, 3rd & 4th instances of

I need your help here. I am trying to calculate a monthly progress of
planned vs. real. My "planned" formula is ok. The problem comes for the
"real" one.
Let's say I wanted to multiply the odd rows from D2:D63 * even rows from

First off, thanks to all who helped me before, works great!
I have rows with multiple info, i.e. name, age, sub-event score and a final
total score.  Is there a way I can have a second sheet sort through these
scores and keep a constantly updating "top four" in each age group?  ...

I have a workbook with 12 worksheets , one for each month of the year.
In each worksheet I have names and address details for people I
sometimes need to write to.
I've made up a template letter in worksheet 13 which I want to use and

This is my formula =IF(D3+E3<C3,"REL",0), this works fine if I need to
release more work but it returns a 0 when I have enough. I would like to have
it return as "blank" (no text, no numbers) when I have enough.
Thanks

I am using a worksheet to track a Baseball event.  One of the sub-events is a
timed event.  Scoring will be based on where you fall into the time
breakdowns.  But this is also broken into three age groups.  What I need is
to be able to enter a time, then have excel go through ...

How to fill a blank cell down to a filled cell above that blank cell.
For example if A1 has Sampath and A4 has Shyla, I would like to get A2 & A3
with the same value in A1, i.e., Sampath.
Can somone who know the formula for this, please mail the same to

This is a bit hard to explain but I have a selection of ranges which I need
to be able to choose from and paste into another workbook.
For example, option 1 could have formulas or values in rows 1 to 4
options 2 might have a different formulas or values in 6 rows.  

I created a procedure where I defined a matrix "V" with row 100 and
column 6
Now I want to sort it's row according to the value of it's last column.
To get this, I wanted to know how Excel does this, through recording a

I have a spreadsheet that refers to a bundle of web tables from a website. I
want to be able to mass replace the links on my spreadsheet so that a portion
of the web address being references gets changed
eg. Current address

I am trying to subtract a beginning time from an ending time. If a3 is the
beginning and a4 is the ending, how should I set up those celsl and what
formula should I use to get the answer I would also like to total the total
time column. . I would prefer not to use military time if ...