I would like to run a report that looks up the first 3 rows of data for each
client in my table.  If I do a VLOOKUP it automatically pulls the first row
for each client, but that's it.  Is there any way to extend that down to the
top 3?  Here's an example of what I'm trying to ...

I am doing vlookup on 2 spreadsheets. One has names capitalized and the other
does not. I am trying to compare the sheets and see which names appear on
both sheets and those that do not. Does the fact that some names are
capitalized and the others are not make a difference?

I have a spreadsheet that has names entered in CAPS. How do i take the CAPS
off the whole spreadsheet?

I have an Excel workbook with over 30 worksheets and when I add a Hyperlink
to a place within the document it tries to open the file again.  Any Ideas?

nI have a drop down menu in C1 with approx. 20 options to choose from.  I
want C2 to turn red if a particular option is picked from the box (this
applies to 1 out of the 20 only) - how do I do this?.  Any help is
appreciated.  Thanks.

I have a question about writing a formula.
the value of b3-c3=d3, I already have that but if the value is greater than
5, I want the value in E3. If the value of d3 is less than 5 iI want the
contents in F3.

When I lock 2 cells that are next to each other (C13 and C14 for example) and
then insert a new row (between C13 and C14), the new cell (C14) is locked as
well, which is not what I want.  How do you insert a row bewteen 2 locked
cells and have that new row have no locked cells???

Even when I choice SAVE AS TYPE =csv, it does not convert to csv.
Is there a setting that I am not aware?

I have a spreadsheet in which I am pulling data from some cells into others
(i.e., a simple "=C24").  The problem is that, when I enter data into the
cells, if there are more than 3 consecutive cells that pull from another
column then Excel copies the pattern and applies it to ...

I have had Excel 2002 on my computer since I purchased it.  I went to open it
recently & it came up with a install box asking to insert Microsoft Office XP
Professional with Front Page.  I am a licensed user and do not have the disk.
I recently took it to the computer shop for ...

I have about 290 text boxes (list) on the left side of the worksheet numbered
sequestionally.  Just like a list.  I have tabulated data across the page
(left to right) using a formula to sum the columns across the page for each
of the 290 items.  What I would like to do is to ...

How do I creat an input mask for the the Canadian postal code?  
I would really like the person the be able to type v2v2v2 and have it
formatted V2V 2V2. I can do this in Access so I was hoping I could do it in
Excel. It's either an input mask or formatting - I really don't know ...

Can anyone help me with the following code?  I am trying to lock a row based
on the results of two formulas.  If either one of the results are greater
then a certain value then the row will lock.  The following code locks the
cell if the first condition is met but not the second. ...

Hi All!   I need to unprotect (forever) a workbook in Excel 2003.   I've
tried doing what Help says (Tools > Protect > Unprotect Workbook); however,
no matter whether I save the document, or resave as a new document, the file
keeps coming up as either a read only or as a password ...