I have a price chart with the following information:
Qty:              500   1000   2500   3500   5000
Lot Price:     269     308     421     503     585
Add'l qty:     .14       .14     .09      .07     .055

Can you please tell me what the 0 stands for at the end of this formula?
=INDEX(A2:A6,MATCH("Belfast",C2:C6,0))
Thank you.
S

I need the formula to convert numbers to a standard date format.  Some
examples are as follows:   16330
22364
19215

i have two forms. One is a sales form the other an inventory. I want to know
how to have the quantity displayed for a given code on my inventory form
based on the sales form. However, the code may appear anywhere within a range
of rows on the sales form, and not necessarily in ...

I have a worksheet, which is protected. On the sheet there are several
unprotected cells. Other user should have the possibilty to add remarks at
the unprotected cells. But, although the cells are unprotected, it seems not
possible for them to add remarks. The option is light ...

How do you creat a drop down list of  data or categories that you can select
from in Ecell? Example: I have a form in excell named "Course Category" under
it is a list  of  my couses that I manually had to type. Is there I way I can
link to another form and choose between ...

Looking for a way to conduct a "LOOKUP" in a random array of cells, ie
A1:A25, B2,B5,C2,C5 find a specific result and return a value of "X" in a
specific cell.  

I am trying to total the occurrences of comma delimited numbers in a column.
See original post below:

I am looking for a way for Excel to calculate stakes based on odds for a
betting challenge we have at work. For example, if I have a target of
getting 100 pennies what stake would I have to put in according to the
odds given ?

Im trying to make a formula that places a X in a week day (Sun - Sat) when
compared to 2 dates.
if A1 is the date 10/05/2006 and B1 is 13/05/2006 then cell C1 is Sunday,
D1 is Monday, E1 is Tue,  F1 is Wed,  G1 is Thur, H1 is Fri, I1 is Saturday  

I have a spreadsheet in Excel 2003 and have the following problem.
Details. It is a protected worksheet, but the malfunction occurs whether
it's protected or unprotected.
Whenever I try to copy (works fine and is visible in the toolbar) an item

Is there a way to use the name of a worksheet in a formula?
I would like to use the 'if' function and have one of the criteria be
the name of the worksheet.
Thanks

Good afternoon:
I am fairly new on using excel I am trying to format a PMT
FUCTION for a mortage payment.  The interest rate is 7% years of loan
life is 5 and loan amount is $10,000.  How would I go about formation

Hi,
I table of 3 digit numeric fields, data in field can be 1-3 significant
digits. I use the numbers as input to another look up that requires all 3
digits and filled with zeros. So I need a formula to determine number of

I am trying to parse text string cells of various lengths and seperated
by spaces. I have thousands of rows of data. I can parse with break
lines at the spaces, however I need to parse where the first whole word
is in uppercase and for that word (in this example CURRAMBINE) to be in