DGet Function

[Frank Kabel]

Hi
seems to be a formating issue. Try
=--'customer'!A1
as reference instead. does this work?

-----Original Message-----
I have a database that I would like to querry based on

results returned from a combobox. In the combobox is a
list of customers linked to a cell with a range name
called "Customer".

The formula I am using is = DGET

(database,J$182,$B$230:$e$231), where $J$182 is the column
heading on the first row of the database, and
$b$230:$e$231 refers to the criteria below.

Cust_ID Press_Type Config_ID Color_Code
1 W 1 1

Under Cust_ID the "1" is actually a reference i.e. "=

Customer" This returns #num! because all customers are
being returned. If I override the reference and type
in "1", I get the proper results. Any Ideas how to make
the querry dynamic? I need to use the results from the
querry for calculations in another portion of the
spreadsheet