|
|
|
Page 1 of 1
|
[ 1 post ] |
|
| Author |
Message |
|
jhummer
Solver Employee
Joined: Wed Mar 17, 2010 2:49 pm Posts: 480
|
 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 |
|
|
|
Page 1 of 1
|
[ 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
|
|