I recently started a major project for the company I'm working for, and
I've been struggling all morning trying to figure out how to get where
I'm going next.
Currently, I have all my columns, about twenty of them, in one

Suppose cell A1 contains a string that could be Table1, Table2, or Table3.  
And that I have a vlookup for which I want to use the table specified in A1.  
How do I specify that A1 represents a Table name and is not a table itself?  
I can imagine a function of =namedrange(a1) which ...

=SUM(IF((Gentex!$C$7:$C$2000="Panamic")*(Gentex!$AW$7:$AW$2000=$A6),Gentex!$G$7:$G$2000))
I want to sum what is in column G only if the 2 conditions are met in
column C and column AW.  I get the #value as a result.
Any suggestions.

Anyone,
Can you make a cell = 0 if original function is creating a"#ref!"?  
Normally, I can manually change the refs to 0, but for large worksheets, this
is not practical.

I have a workbook that has 20 or so different worksheets, one per department.
Each worksheet contains the department budgets.  I need to consolidate the
department budgets onto one worksheet so I can upload it into our ledger.  
For example lets say there are 5 accounts listed on ...

I posted an item below.  I think the Address function is creating the formula
I need, but is there a way for it to return the value in the cell instead of
the formula for the cell?
From Help:

Trying this again.
I am using this Public Function:
Dim oFC As FormatCondition
Dim sF1 As String

I have a questionnaire on an Excel spreadsheet with 20 yes/n
questions. What is the best way to create a spreadsheet with the optio
of a "yes" or "no" box that can be checked one or the other exclusively
For example:

How do you display the pivot table field list

Is there a "go to" function in Excel? What I want to do is have a conditional
if statement where if data in the previous cell equals a given variable, then
you would be automatically redirected to another cell.
This is what I’m trying to do: =if(c11=”x”,go to d11)

I need a forumula that will give me mulitipal answers.
I have a constant value that is looking that value up in a chart and from
that constant value I need it to return the corresponding names.
ie #01001

I am trrying to insert a date picker in an excel file, similar that which is
used in Infopath. Is this a possibility of impossible?

=IF(B10="TWILL SHIRT",M2,0)
B10 IS A DROP DOWN LIST. I WOULD LIKE TO HAVE THE TRUE RETURN BE DIFFERENT
DROP DOWN LISTS CORRESPONDING TO EACH ITEM IN B10.

Does anyone know a way to use a referenced cell (containing text) and
have the parent cell use that text in the formula?
As an example.
In A1 I have "B1+B2" (stored as text, not an equation)