dear
i have a database of three sheets, and i want the vlookup in sheet 4, when i
use this formula  =IF(ISNA(VLOOKUP($C3,'sheet
8'!$A$2:$F$58,2,FALSE)),VLOOKUP($C3,'sheet

When I sometimes rename a sheet it come back .xls]Newname? What's with
the ".xls]" portion? I didn't put that there.
Thanks.

I want to be able to say:
If E38 is less than or equal to $17.99 then E44 is E38 plus $5.95 and
If E38 is between $18.00 and $23.99 then E44 is E38 plus $6.95 and
If E38 is between $24.00 and $39.99 then E44 is E38 plus $7.95 and

Is there a way to move data from one column to another and have it
automatically update the row number by 1?
Example:
Move Col-A        to         Col-D                  

I'm working with a fairly complex PivotTable in Excel 2007 and I'm
hoping that somebody can help me out.  Here's the issue:
One one sheet of my workbook, I have a big table of data.  Every row
represents a particular date, and I have several columns with numbers

I am knowledgable how to get a SumIf from one column based one or more
criterias from only one other column. However, now I need to compare criteria
from two different columns and return the SumIf from a third column. I tried
Concantenation, but to no avail and even tried nesting ...

I am putting together a pivottable and would like to be able to filture the
report for all records that are less than a certain date.  However, it does
not appear that the "Date Filter" option is available for fields you put in
the Report Filter section.  Am I missing something?

Is there a shortcut to unhide all columns and rows that are hidden at once?

I'd like to take all the comments from a single row, copy them and
paste them into another spreadsheet, is that possible?

I'm having trouble opening an Excel file.
First, I have researched this board.
I have made sure Tools>Options>General uncheck "Ignore other Applications"
is unchecked.

I'm attempting to construct a countif statement which is conditional on 2
seprate columns of data using the following formula produces a 0 response
=COUNTIF($K:$K,(AND($C:$C=1,$I:$I=0)))
What I need:

  I need to add an autotext field (or whatever the correct term) is so I
can add the copyright year to the footer, so the copyright year can be
updated as needed.
How do I do this?  I can easily add the date, but I only want a year field.

=AVERAGE(IF(('Production Calendar'!C11:C101="Memco")*('Production
Calendar'!D11:D101="PLBF"),'Production Calendar'!G11:G101))
this equation works but if the are no PLBF, Memco employees yet is shows up
as #DIV/0!. If a PLBF, Memco employee is added I would like the equation to

Hi, I will try to get this right,
I have a list of names (multiple identical entries) each name(column A) has
a date in the next column(B), & a figure in the next(C),
I need a formula that will find a specific name in column A then check to

I am using =H4+30 where h4 is my date cell for my quote invoice but when h4
is blank I get 1/30/00 how can I make it show blank when h4 contains no
information