I am setting up a layout or template on the main (master sheet) sheet. All
other sheets on the same workbook will have the similar layout. The question
is, what can i do so that whenever i add additional table/s on the main
sheet, it will automatically update the layout for the ...

What is wrong with this formula?
=IF(AND('Node 01'!A1:A1000=A22,'Node 01'!B1:B1000=B22),'Node 01'!H1:H1000,0)
Looking at "A" and "B" for a match and the anwser is "H" the same row as "A&B"

I have a sheet which looks as follows
Sheet 1
COl A  l  COl B          l COl C                              l COl D
Name  l  Tax            l Tax Recpt No                    l Date of

I have a bunch of cell with varying lench that have numbers at the beginning
(also of varying length. Ex:
1258 ahjKJ yuUIOI
45687045HJKoiuwER

I am converting a budget spreadsheet from Lotus 1-2-3 to Excel.  Excel's
limit on nested IF statements is creating my biggest challenge.  I have
budget and actual  columns next to one another for each month.  A Lotus
formula reads from a cell identifying the current month that ...

I want to build a dynamic formula from values from different fields and be
ale to execute it as a formula. I'm able to get the value in a cell as
"=A1+A2" but not the result.
Any guss on how I can do that without using Copy + Past Special/Value and

In an existing workbook I have a blank preformated and preformulized
worksheet. When I copy this worksheet into a new workbook all of the column
formatting and formulas are deleted. Can this be fixed in this version of
Excel? Your help is very much appreciated!

I seem to be unable to copy or paste anything.  The icons on the tool bar are
shaded and unable to be used.  Even if I right click the copy and paste
options are also shaded and will not work

I have got a list of dates in a Excel spreadsheet with day and month in the
first column 'A' and the corresponding week day in the second column 'B'. I
obtained this list just by writing the date and week day in the first row and
then drop down the list I needed.

Hi
I am using excel 2003.
I have 3 columns: ProductID, ProductName , Units Ordered.
I want to lookup double records in de column "Product ID".

I need a formula to find the average of the best 8 scores of anywhere
between 8 and 15 scores
Thanks in advance

I need to compare a column with a set of columns and get the column number
that match the lookup column. Can somebody help? thanks!
lookup column:
1

The help page for the DCOUNT function is a little confusing.  I am trying to
count the number of cells that meet criteria in 2 different columns.  For
example, I have a column of cars by model and a column with the month and
year the cars were purchased.  I want a count of each ...

I have 2 columns; first column is the code and the second one is a
description of the code.
I am trying to create a dropdown list on a seperate sheet so that when
I select the code, it should return the description.

Trying to do a formula as follows:
Sheet1                                               Sheet2
Account #        Monthly     YTD             Account #    Code        YTD
510000            5,000.00    15,000.00     510000       Expense    $50,000.00