Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NA
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|