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
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