=VLOOKUP(TEXT(F5,0),Jobs!A:B,2,0)
The formula you gave me above worked great until I added a few more
rows of data to the Jobs worksheet.
Any entry that was added past the original entrys will not lookup.

Lets say I have range A1:A5 containing values 1,2,3,4,5 respectively.  I
would like to count how many of these cells are odd and place that value
in  A6.  The same for even numbers as well (in A7).
Any help would be appreciated.

When i convert an excel page into a pdf i get corrupted scripts etc ie italic
changes completely. Does anyone else have the same problem? Is it because it
is a beta version? Is there a cure? When using excel 2003 i have no problems.
Ta

I have my own Menu application that I can easily open files or create new
files based on my templates. (I use CDMenuPro to make this). It's easy to
make a button that open MSWord, then run a macro at the same time to open a
template that I created. But I don't know how to do the ...

Really embarassing newbie question:
I have two sheets of data, both sheet have a common identifier "school
code".  One sheet has some results (numbers) for each school code that
I'd like to match to the school codes on the other sheet.  I can't seem

How can you make excel search for the values you enter in a cell in
another worksheet which contains two columns of data ,Jobcode and Job
title.
I want to be able to key in a jobcode on the main worksheet column

Does anyone have any idea on how to facilitate the preparation of surve
results?
Our survey results are downloaded from our survey online facility (som
facility when it can't even produce the report :sigh:). These survey

It's for a Nested Function.
Enter this function in cell B1 and then use the fill in handle to copy
the function down through cell B7. Enter the following data in the
cells in the range A1:A7 and then write down the results in cells B1

I am using excel to add users to AD, I need to have a function that will
look through my username column and find matches and highlight them, can
anyone advise?
Regards

I am trying to pivot table an uneven flat list that looks something
like below . .
Rep Q2    Rep Q1    Rep Sales
=========================

how do I print envelopes with customer addresses from excel?

i am trying to do a stock and order for work. i have to divide the amount of
sales by the quantity of units in a case to come up with ( cases required to
order). i have done that but i need to average that total into to three
cells. e.g  12 = 4 4 4,   11 = 4 4 3

A column contains a list of dates in the form: day/month/year.
If the list contains all single-cell days, then sorting in descending
order works fine. However, if the list contains a date such as
24/4/2005 as opposed to 2/4/2005, the date 24/4/2005 always appears

Does anyone know why Excel sometimes does not see
user-defined functions, and instead fills the cell with
"#NAME?"?
(I have run across this problem before, but I do not

Is there a technique or add-in utility that will let me do a data sort
in Excel
to 4 or more levels at once. Currently you can only do 3 levels, and
then you have to separate the data to do more.