#NUM error

chrispy

Board Regular
Joined
Apr 26, 2008
Messages
73
I have a data base on Sheet1.
On Sheet2 I use the formula =DGET(Sheet1!$A:$F,6,Sheet2!A4:B5)
This works good except for one. I get #NUM error.
I believe all cells are formatted correctly.

Any ideas why this result?
<!-- / message -->
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
The Excel Help shows:
The #NUM! error value occurs when a problem occurs with a number in a formula or function.

Have you checked out the above?
 

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,610
Office Version
2013
Platform
Windows
Often a problem in the source data - an error value, maybe some number formatted as text, or a text value (a space, a hyphen) - anywhere in the ranges referenced.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,358
Messages
5,413,994
Members
403,511
Latest member
Emmanuel John

This Week's Hot Topics

Top