I am attempting to have a variable reference to the table array in the
vlookup function.  I have created a pull down list in A1 and want the results
of the pull down list to then reference the name of a corresponding table
array lookup.  It seems that I have to either reference ...

We have created an Excel radio log for our dispatchers to use to track all
phone calls, EMS and Law Enforcement traffic.  We have some dispatchers that
are not good typists, and we have repeated traffic in some instances.
I am trying to create a validation list for the constantly ...

I am currently having problems with the Networkdays calculation in that
my received date is keyed straight away but my due date may remain
blank for sometime.  It being blank then throws up a negative number
such as -27887.  Is there anyway to have the cell return an "N/a"

I am in process of creating an Excel template file that will be used by
multiple users who may have multiple versions of MicroSoft Excel on their PC.
The user will download the Excel file from my site, enter information in the
file and then upload the data to my website.  Most ...

I have filled in some cells with different colours, using the fill tool
Red
Blue
Green

I am trying to find a lookup formula that will use TWO different variables.
One value is on the horizontal row one on the vertical of a spreadsheet. It
must then lookup on a separate sheet and return a value, providing BOTH
values have been found.

I would like to use the value of a cell to be the name of a sheet in a
formula. So for instance:
A1 contains the word "Sheet1"
A2 has the formula "='Sheet1'!C3"

Hello fellow helpers,
I have created the following equation:
=IF(AND(N10="Large",O10<500),"Incorrectly
Categorized",IF(AND(N10="Medium",O10>500,O10<80),"Incorrectly

How can I select and paste a picture into a spread sheet based on data in
Excel 2003?  I only have 10 pictures and four criteria.  What I'd like is
something as simple as an IF statement and I could store the pictures on the
spread sheet  Any ideas?

Hi, first time posting here...I am trying to make a cell (A1) with a
date in it turn red within say 15 days, and then turn back to the
original color when the completion date in cell B1 is inserted.
Basically I'm making a training spreadsheet that will show training

There are countless Aluminium smelters accross the world and most of these
have 288 cells per potline, it would be excelent to be able to fit all of the
cells into one sheet for analyses. Currently we have to split the cells in
groups of 144 pots per worksheet for analyses, this ...

I am a little confused as to what can be entered into the criteria par
of a countif statement.
For example if i wanted to count all the cells in column A that onl
contain one character how could I do it just using the counti

Is it possible to seperate a coloumn of data to individual coloumns by
using a delimiter of consecutive capital letters or where a capital
letter exists in a line of text:
eg. JohnSmith  --> | John | Smith |

I need to use the largest figure in a part of column D. The part is
defined with the lowest value of the range always being D2 and the
highest being determined by the number of used cells in column B, eg.
if column B contains 32 used cells then the range is (D2:D31)

Does anyone know a fomula or function to convert yards to miles and yards
i.e. 2000 yards equals 1 mile and 240 yds not 1.14 miles.
Thanks