I am not understanding how to use vlookup.
On my Master Worksheet cell B11 contains a number. I would like a formula
which will go to worksheet  Accrual  and find the number in column A and
then return the value in column B.

I am trying to have '0' and '#N/A' if they occur replaced with "".
If I place a '0' in A1 and use the formula =IF(A1=0,"",A1) then fine I get
"".
If I place a '#N/A' in A1 and use the formula =IF(ISERROR(A1),"",A1) then

I'm running Excel 97 SR-2 on Windows XP (and have found the same problem
running Excel 97 on Win95). When copying a cell containing an 'IF' function
that references a column label, the reference is an absolute reference rather
than a relative reference. For copying other cells ...

Hello, i have a weekly table monday-sunday (B, C, D and so on) for each week
of the year, persons are in A2, A3 A4 and so on, if a person is free on one
day of the week the cell is empty, now i like to have a new table wich counts
all the empty cells of a person on monday, all of ...

Using Excel 2003.  I have a workbook with 70 worksheets already created.  I
want to print these with the tab name as the header.  I can get this to work
on one sheet at a time but I would like it to be the same on all worksheets.
Is there a quick way to get this on all sheets at ...

I feel really dumb having to ask this question, but I don't see the split
boxes on the scroll bars anymore - do they exist in Excel 2007? According to
Help they do. I've looked at Excel Options, but can't find where this would
be an option that has to be turned on. Anyone know ...

I just upgraded my Office 2003 with Office 2007 on an EP Pro machine.  The
only snaffoo I find(so far..) is with Excel 2007.  When I double-click on an
Excel 2003 file, Excel 2007 starts up just fine, BUT my file is not
displayed.  At that point if I click the Restore button up ...

Hi! Every Body
This is my second post in this site
I am very disappointed with my first post solution because i can't
find any specific solution. But this time i will hope that i will find

In any given row, if the cell in column A of that row has a value entered, I
want it required that a user choose something from a dropdown menu in column
D.  How can I do this in Excel?

I have an excel 2003 worksheet that was designed by my predecessor. She used
data validation to create a drop down list with a number of names. However we
need to add a couple of extra names to the list and I can't seem to figure
out how to edit the list. I could just erase the ...

how to lock a single cell in ms excel by not a worksheet

how to apply a single macro to all worksheets????????

May I know how to number unhidden rows only

There must be a way of doing this, but I cannot see it.
I have a spreadsheet with items to be progressed. This list can be filtered
on a number of criteria. The filter currently only works on the first 1000
rows. It is not considered likely that it will ever go above this.

I Don't want to bore you with details.
I have Excel spreadsheet which I would like to be accessed from any PC with
internet connection.
What I would like to do is to host the workbook on-line and issue logins to