robbyn
OOo Advocate
Joined: 29 Mar 2004
Posts: 308
|
 Posted: Tue Jul 08, 2008 2:41 pm Post subject: Pilot tables and VLU |
 |
|
I have taken to combining the results lines in Pilot tables with VLU so as to code up the results of the pilot table. In order to avoid n/a results I have used the following
IF(ISNA(VLOOKUP(H74;$H$176:$K$260;4;0));0;VLOOKUP(H74;$H$176:$K$260;4;0))
It is a bit cumbersome. Is there a better way of coding it?
_________________
Robin
When you love a delicate rose remember she has thorns and a root. In time the petals will fall away. |
|
