look in the help index for ISNA

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Duplatt" wrote in message
...
I have this formula
=hlookup($a$1,sheet1!$a$21:$ap$41,1.false)
It works fine but, returns #NA if $a$1 not found.
How can I make it return "out of range"
Thank you
Duane Platt