Need to replace result value from DGET() function for the not found condition?

[hrithik]

when search a database using DGET(), I get "#VALUE!" returned when the search fails.
Is there any formula to return "" (blank) instead?

 

[harshab6]

hi,

try this <TABLE style="WIDTH: 313pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=417 border=0><COLGROUP><COL style="WIDTH: 313pt; mso-width-source: userset; mso-width-alt: 15250" width=417><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 313pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=417 height=20>IF(ISERROR(DGET(A1:A4,B1,A1:A4)),"",(DGET(A1:A4,B1,A1:A4)))


I have selected my own ranges with my examples but this formula will return a #value as blank.

regards
harsha
</TD></TR></TBODY></TABLE>

 

[Aladin Akyurek]

Duplicate of:

http://www.mrexcel.com/forum/showthread.php?t=484726