DGET Partial Match producing #NUM! Error

Question

I have been successfully using DGET in Excel for some time now, but new data was added to the database I am using that is named the same but has additional characters added to the end.  One of the items that are being looked up is called "K010" and the new data item is called "K010-P".  I do not want to alter the data.  Is there a way to force DGET to only find exact matches and not attempt to search on items that start the same and have additional characters appended?

Answer 1

Ok I will try to get an example together to post here in a bit.

Answer 2

Well, the hope dies last. :-)

I agree to Ashish Mathur: Share some data and show the expected result.

Then we can show you some workarounds.

Andreas.

Answer 3

Hi,

Share some data and show the expected result.

Answer 4

Thanks for your response, however I hoping you are not right about this.  I'm looking up text not numbers and using an exact match to 5 different cells within a row, so other formulas are not practical for this purpose without concatenating.  I am trying to not have to add a concatenation column for lookups.

Answer 5

AFAIK there is no way to force DGET to this behavior, in such cases you have to use SUMPRODUCT or INDEX/MATCH formulas.

Andreas.