#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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

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,604
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,089,886
Messages
5,410,973
Members
403,336
Latest member
amreeves87

This Week's Hot Topics

Top