Just for the record, in Excel 2007 you can use the new IFERROR function.
E.g.,

=IFERROR(your_formula,result_if_error)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Darts via OfficeKB.com" <u19990@uwe wrote in message
news:6c88e3b6351d5@uwe...
I am copying down my formula and in areas that i don't have any data the
result is N/A
here is my sample formula
VLOOKUP(D11, 'Pay Rate'!$D$2:$E$8, 2)

thanks
for your help

--
Message posted via http://www.officekb.com