I see were you can use that selection if you are using the find command in
edit. How do I apply that function to my formula:
=IF(E6=1,(DGET(Sheet2!A1:F191,"ALM_Current
24HRMS",H5:I6)),(DGET(Sheet2!A1:F191,"ALM_Current 24LRMS",H5:I6)))

"Jim Rech" wrote:

Re Find, make sure you select "Match entire cell contents".

--
Jim
"GE Johnny" <GE wrote in message
...
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.