The function itself works, tested with other calls.
The call which fails is:
Colors: Concatenate("SELECT [Sizes for Items on Selected Prebook].[Size]
FROM [Sizes for Items on Selected Prebook] WHERE [Sizes for Items on

I have 2 columns - Document Type and System Numbers.  Based on this, I have
to look up the date when this is occuring. i.e. Column A - Doc Type, Col B -
System #, Column C - Date.  this data is available in 1 spreadsheet.  Now I
have to transfer this into another spreadsheet in a ...

Have in column C values, some of which end in =T.
I have data in columns D through H some values(numbers).
I'd like to do two things:
Obtain the number of cells that are in each column that have a

I've got data about different retail branches.
Amongst other fields, I have a column called State which says which
state the branch is in.
There's another column called Special Branch which is a Yes/No column

The formula below returns the the name associated with the lowest
value in a range. How would I tweak this formula to return the 2nd
lowest value?
INDEX(A8:A34,MATCH(MIN(G8:G34),G8:G34,0))

Is there a way for a formula to return a true blank?
I'm trying to do a query, for either DCountA or SumProduct, that refers to
another cell for the criteria.  I wish to have that criteria ignored if it is
blank.

Hi I need help determining the proper way to make this formula work in my
excel sheet: if h8<8 then i8=H8-8.  I am trying to make a time card and I
need to put all hours worked over 8 in a seprate column.  I would also like
to make it so the total in column H8 can not be greator ...

I have a spreadsheet with 2 lists of data, each list contains a number of
columns, the 2 lists are not equal in length, list 1 is about 2,600 rows and
list 2 is about 50,000 rows
The left most column in each list contains part numbers, these are unique

I have a Workbook with several sheets on it, and I want to have a pop
up reminder so that people who work on it are asked if they are using
the correct sheet.
I basically want it to say "Are you sure you want to Enter data on

When doing v-lookup from one spreadsheet to another, it displays the formular
instead of the result.  I pulled the first set of numbers out of a database
and made sure they are all numbers, not text.  The second set of data was
sent to me and seems also to be numbers.

I have the following data layout
Col A to E (Row 5) with values say, 10,15,20,25,30
Coll A to E (Row 7) has values say, 15,10,10,30,35
Col A to E (Row 9) returns an "Under" or " " (blank) depending if Row

I have a few question about processing data in excel, but I got no
idea how to use VLOOKUP function to solve this,
here is the example :
I got this data

I need to log info from a request form in excel to a separate worksheet that
will add info from the original request each time it is modified, without
changing the previous info.
Any suggests for the proper formula? I was trying an If/Then formula but

I want to be able to put a random series of names in a particular cell of an
excel file.  This is  a mail merge from 1 excel file to a cell of another
excel file.  For example, I have an inventory that will be done for different
places (lab, classroom, office).  Each of these ...

I created a spreadsheet in Excel XP for all my investments and used the MSN
Money Stock Quote add-in to update the daily activity values.  I recently
upgraded to Excel 2007 and now can't get the data to appear in the cells.  
Where I used to get a value, I now get #VALUE!.  I have ...