I wonder if you can help me.
I am trying to use VLOOKUP to do the following:
- I have a two column table, the first has words in it and the second has
percentages.

I have a client who has always imported comma delimited files into Excel and
then copied that worksheet into a master .xls workbook using the Move
function.  With Excel 2007 this is no longer working.  It gives an error
stating that the destination does not have enough rows and ...

I am using the following formula, which works really well and brings back the
data that I want it to:
=INDEX(Data!$B$13:$B$35,MATCH(MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-5),Data!$A$13:Data!$A$35,0))
However, ...

I have three adjacent columns, A, B and C, and wish to sum the total number
of entries of '/' in each column and add the total from column A to column B
to column C.
In A I have '=COUNTIF(H21:H26,$E$229) ' where $E$229 = '/'

I an running Excel 2007 (part of Office 2007) on my Win/XP
Workstation.
For both cell background and text colors, the new menu system has
"Theme Colors" and "Standard Colors".  I know I can also choose "More

Just installed Microsoft Office and have Excel 2003.
Trying to email an Excel spreadsheet as an attachment,
but message "no profiles have been created.  to create a
new profile use the mail icon in the control panel"

I have to fill out a payroll form each week for each contractor showing
gross, deductions, net, hours and wages for each one. I have a form in
formtoolv5 that I go in and edit. My quickbooks will download the payroll
information I need into excel, but is there a way I can import ...

When I insert lines or columns in a spreadsheet, any vector objects (graphs,
clipart, drawings) that overlap the inserted lines are enlarged. However
this does not happen with bitmap images.
Is there a way of locking my vector objects so that they remain the same

Hello Roger,
A few weeks ago you set up some formulas for me, (my message was entitled
"new user needs help") and they are working wonderfully!  However, I was
wondering if it's possible to do a couple of extra things: a) can I have a

I have numbers on SHEET2 that are all 7 cells apart:
A1
A8
A15

My program takes a name from sheet3 goes to sheet1 to Find the name.
If it cannot find name, how do you do an If/End to Exit Do while or
find out if name has been founf? I have "On Error Resume Next" in
program.

I have a chart title linking to a cell that says:
="$5,000 invested annually @ " &average(U2:U40)
Is there a way to limit the decimal length to only two places here?
I've explored formatting and it's stuck at displaying 14 decimals.

Windows 2000
Xcel xp
Monday morning ....  and some how over the weekend the macros connected to
the toolbar disappeared.  

I am receiving a message in newly installed Excel 2007 when opening a
spreadsheet in Excel 97 format that I never received when using Excel 2003.
The error message is:
"One or more invalid names were detected in this workbook.  Those invalid

I am a new user to Excel -- I apologize in advance if I don't have the
correct vocabulary for my problem.
I am using Excel 2007.  I have accidentally "locked" my Excel file (I was
trying to execute a command in another program and clicked on my open