I have a worksheet with info from 2 databases. I'm trying to match names
in different columns that have different formats. One has LN, FN,
Initial format with info presented in 1 column (Column B), the other
has LN,FN with info in 2columns, H:I, all names sorted alpha ascending.

When you are creating a vlookup, does the lookup table HAVE to be sorted
alphabetically to work, or the lookup table and the original worksheet?
I've been working on a lookup for a while and always get N/A so i know i'm
going wrong somewhere.........

Sorry for any repetition with previous questions but I am completely hopeless
with excel functions and got lost when attempting to use functions contained
within previous postings.
My problem: I have a questionnaire for 27 sites. For each site I have the

Is it possible to write Excel formulas and reference the active cell as part
of the formula.
Use:
As you scroll you data, a cell at the top of the spreadsheet would show the

I need to transpose a column to a row without using 'Paste Special'. How do i
get the second value when using the formula {=transpose(array)}?
tim

Specifically, I want to restrict from view a specific range on a sheet where
I have someone entering data ... I need them to enter data into rows which
will create sensitive information in cells below (these I want to hide from
all but original creator) ... any ideas??

Hi I have 2 ranges of cells named data1 and data2. I want to use these ranges
in one lookup formula by use of a drop down box.
If I type directly into the lookup formula "data1" as the table array the
formula works. Is it possible for the table array name to come from the drop

The password I had written down did not work, so apparently I changed it and
failed to write it down.  It is a worksheet I do not use very often and is in
a file that other departments have worksheets in and view, thus the
protection.  I realize I blew it . . can anyone help me?

Are there any golfers out there who may know the formula I would enter
to establish stableford points from strokes entered??
Regards from Kenya
Aussiemike

I'm trying to do a bit of a survey analysis.
Anyways in counting responses this is what i need.
I need to run the COUNTIF function for a particular column, but i only
want this function to run IF the column adjacent to it has a particular

i format all cells in D,E,F and G to currency and try to typ for example
1459.70 in cell D but it returns just this ########.
Can someone tell me why ?
Thank you in advance

i need to insert a zero in front of a range of numbers
7011117050
7011117051
7011117052

I would realy appreciate if someone can help.
Here is my question,
1) Is there a function if i type in a cell for example  500£ that it will
be displayed at the same time in other cells?

i just started to use Exel 2003 and would realy appreciate if someone can
help.
Here are my two questions,
1) Is there a function if i type in a cell i for example  500£ that it will

My queire is
There are many customers and each customer can purchase limited amount
of quantity in a year as per govt rules. these customers purchase
monthly or quarterly, etc., a particular quanity.