OK....

Just change the last argument in the lookup function to FALSE or 0 for
short:

=IF(N460="","",VLOOKUP(N460,IDNumbers,2,0))

Biff

"Biff" wrote in message
...
Send to:

xl can help at comcast period net

Remove "can" and change the obvious.

Biff

"Dallas64" wrote in message
...
I would love to send you a copy to look at, but I will have to strip some
confidential information off first. How is the best way to get a copy to
you.

"Biff" wrote:

Hi!

Hard to say what's causing your problem. If you want to send me your
file
I'll take a look. If you're interested in doing that just let me know
how to
contact you.

Biff

"Dallas64" wrote in message
...
I am working in Excel 2003 SP1, and am using a VLookup function that
has
worked beautifully until last friday. My function references a named
range
on a different sheet within the same workbook, but I am now getting
error
messages for some lookups, and not others.