My skills are limited.....
I am, creating a spreadsheet for a group of children.  They can complete 1
of 3 tests according to ability and I want to create a function where if test
type is selected (a,b,or c) then a corresponding lookup table can be selected

Im using the LOOKUP functions a couple of times in a workbook and it works
correctly in all places except one.  Here's an example of what is happening:
     A         B
1    Jane     20

Is there anyway that I can add two cells ie.
cell 1 - (5 - Oranges)
cell 2 - (6 - Grapes)
and get a sum of 11 in the third cell...i cant just use the sum

Is there a function that will allow me to display a number (such as 2,435.00)
in the French euro format ( 2 435,00)?
I haven't found a way to format numbers in this fashion that still allows
them to operate as numbers.  (At least, not as the correct value.)

Good day,
When opening up a new excel spread sheet and selecting the insert menu the
columns, rows and cells are grey and unavailable. I am using windows xp with
SP/2 and MS office 2003. I tried to run a repair and reinstall excel and this

I have an excel spreadsheet #1 with column A listing books checked out by
title, column B is the unique barcode # of that book, column C is the
patron's ID # who checked out that barcode #. There could be as many as 800
entries of the same title in column A because each row is ...

I thought I was using the right function command, but perhaps not.  Here is
my issue: I have a roster of football players who have stats set-up in Excel.
I want to be able to, after a series of games already played, forecast or
predict the what the outcome of the next game might ...

I need to create an array formula with 3 criteria.  I have done it with 2
before, but I can't seem to get it to work with 3.  I have to use the Sumif
array instead of the sumproduct because I need to have blank cells within my
table.

I have a workbook with several sheets but want only one sheet to be e-mailed
back to me by my client.  How do I set this up in a simple way for the client
& myself?

I'm not sure of the best way to go about doing this in Excel 2003
Lets say, on Sheet 1, I have a row of client projects. On them, I mark
column L with "Complete" for complete.
I would like Sheet 2 to only display clients from Sheet 1 that have

I have these 2 tables:
Date    UnderLyer    005S0F1    009F00OL
11-Oct    QQQQ    2.92%    1.68%
11-Oct    SPY    0.00%    0.00%

I have my data like this:
10-Oct    11-Oct    10-Oct    11-Oct    10-Oct    11-Oct
and
005S0F1    009F00OL    017S0D1

I would like to compare 2 columns values.  the "+1" is still value.  For example there are 1406 in column A and 14061 in column B in this case the whole row should be deleted from the workbook.
Is there a way to do it with a macro?

A workseet contains a lot of INDIRECT() functions, each INDIRECT() function
contains a link to another EXCEL file.  Seems other EXCEL files should be
open, otherwise, reference error occurs.  Because there are many other EXCEL
files, it is uncomfortable to open many EXCEL windows ...