I am trying to convert a Lotus file over to Excel, and am having some trouble
converting an error handling dget function.

=IF(ISERR(DGET(Databaseread,"Name","GROUP
ID"=GroupNumber)),VLOOKUP(GroupNumber,Databaseread ,4,FALSE),DGET(Databaseread,"NAME","GROUP ID"=GroupNumber))

This is the function that was used in Lotus; it returns the name of a
company by looking at the ID number. I need to keep it as pure as possible to
the Lotus file.
Any help would be appreciated- thanks!
--
earth21994