Dget returns #NUM!

A

Al DeLaCruz

My data list contains values such as 2110, 2113, 2113nor and 2113nor1. Dget
returns #NUM! because it thinks 2113nor and 2113nor1 are duplicates.

Is there another function i could use to make an exact match?

=IF(E6>1,DGET(Data!$A1:$C410,Data!$B1,E5:E6),0)*E7
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question using DGET function 1
Have DGET return Null instead of #Value! 3
DGET FUNCTION 0
DGET Function - using a split criteria range? (Excel 2007) 0
VLOOKUP and DGET to find a value with multiple criterion 8
Function to Return a Date Value Q 4
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 9
Database function criteria 2

Top