i have a situation as follows
Time sheet
col1                 col2                col 3            col4
date                 time               name         total

I'm having a problem here... recently upgraded to a new version of excel
and I've been looking in all the options can't seem to find a solution.
It seems whenever I enter a formula referencing a blank cell on another
sheet, instead of displaying a blank value like on the other sheet ...

Is it possible to use a cell reference (on the same worksheet as the
vlookup function) as the table array argument in the vlookup function
in place of an explicit table array argument?
I'm trying to build a simple reporting tool that would allow me to

I have searched and tried all the weekday/network day etc formulas but
still can't get this to work.
what i have is a column with dates from the begining to end of the
month. and next to it another column with values.

I am unable to see the data analysis option under tools menu. I did as
mentioned at every other place regarding check-in the Analysis Add-in check
box. When I did that, the application did some installation but still i am
unable to see the 'data analysis' option drop down. ...

I have a list of data, about 5 columns and many many rows down.
I used a Advance filter to get a unique list of the Names listed in one of
the columns.
I'm tring to write a formula next to the filtered unique list that looks up

ALL OF A SUDDEN, my copy and paste routines are NOT working...I am copying
down a column a function, if(A3=B3, "WIN", "LOSE"), and copying down.
Instead of returning the proper answer, it is returning the value of the
cell from which I am copying..i.e. NOT the right answer.

Hi I have a problem with getting lookup to return more than one result.
     A     B
  _______________
    pcs   team

Here is the deal.  I have a worksheet, lets call it Sheet1 that has a
ton of data (25,000 entries).  I want gather every 20th cell in column
B from there and put it into lets say Sheet2 so that the data in the
Sheet2 has the following.

I'm trying to substitute/replace text in one cell for another text in another
cell. I don't want the return value to be the original text or a "#VALUE!" in
the new cell if it does not find the text to replace. PLEASE HELP. I'm going
crazy.

I am trying to open a worksheet with links to another program that I do
not have. As such, I do not want the links to automatically update when
I open the workbook.  Even though I select "do not update", the links
still update and I get a bunch of error messages in all of the cells. ...

How can I shorten this formula, I still need to add a few more variable
and everytime I try and add one I get the formula is too long error.
Thanks
=IF(AND(A16="DeKalb",D16="Ponch

I use VC++6.0 to create a temp excel file, and I don't want other use
to modify it, I use _Workbook.ChangeFileAccess to set readonly, but i
cannot help, a exception throw out, the message is "cannot fin
member", when I invoke ChageFileAccess function, the code is lik

Okay so heres what my workbook does thus far.  I set the value in e3 by
looking up the text in b3 in a table array on the second sheet.  I
would like to put this value in d3 if it is not zero.  If it is zero I
want the user to be able to enter something into cell d3.  But I don't

I am trying to develop a form so that I can pull the value of one specific
cell (source cell) onto a summary sheet.  Normally that would be easy.
However, I need to insert a new row in the form every time I make a new entry
on it.  When I do that the "source cell" moves down one ...