Thread: Have DGET return Null instead of #Value!
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
matthoffman33
 
Posts: n/a
Default Have DGET return Null instead of #Value!

Thanks for the help, I'm still having a problem with it though. This is
what I have for the eqation:
=If(ISERR(DGET(RawData!$A$7:$E$6503,RawData!$E$7,A 55:B56),0,DGET(RawData!$A$7:$E$6503,RawData!$E$7,A 55:B56))).
The problem seems to be with the ,0,. Any suggestions how this can be
fixed?

Thanks again,

Matt


--
matthoffman33
------------------------------------------------------------------------
matthoffman33's Profile: http://www.excelforum.com/member.php...o&userid=32148
View this thread: http://www.excelforum.com/showthread...hreadid=539134

Reply With QuoteReply With Quote