Reply to topic  [ 1 post ] 
 IFERROR 
Author Message
Solver Employee
User avatar

Joined: Wed Mar 17, 2010 2:49 pm
Posts: 480
Post IFERROR
With Excel 2007 you can use a IFERROR system vs an ISERROR system. IFERROR is much easier and faster then the ISERROR statement.


=IFERROR(VLOOKUP($D8,INDIRECT($C8&"!Seg"),F$7+2,FALSE),0)


Wed Jul 27, 2011 11:00 pm
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 1 post ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron