Thanks so much for the help. I have been trying to get this array to work but
I've had no success. I keep getting #N/A for a result. I think it might be
something with my criteria for cells H6 and I6.

"Harlan Grove" wrote:

GE Johnny <GE wrote...
I am using DGET to retrieve inforamtion on a spreadsheet. My problem
is Excel is seeing duplicate information when there is none. Excel
is seeing MGC-HDVM and MGC-HDVMH as the same text. If I remove the
dash then the problem goes away. These are part numbers I am looking
up and I would like to show them as they appear with the dashes. I
have the same problem if I use the find function. When I type in
MGC-HDVM and click on find it also displays MGC-HDVMH as if it were
the same text.

This is one of many problems with Excel's DGET function.

As a practical matter, you'd be better off using an array formula
which calls MATCH. Given the formula example in your follow-up
message, try the array formula

=INDEX(Sheet2!A1:F191,MATCH(TRUE,(H6=<this)*(I6=< that),0),
MATCH(IF(E6=1,"ALM_Current 24HRMS","ALM_Current 24LRMS"),
Sheet2!A1:F1,0))

where H6=<this and I6=<that are substitutes for the criteria in
H5:H6 and I5:I6, respectively.