Bob Phillips wrote:
|| Sorry, I don't understand what you mean.
||
|| --
||
|| HTH
||
|| RP
|| (remove nothere from the email address if mailing direct)
||
||
|| "Gordon" wrote in message
|| ...
||| Bob Phillips wrote:
||||| - reduce complexity of formulas that have repeating functions -
||||| create a name a make it more obvious and also shorter (e.g.
||||| =IF(ISNA(VLOOKUP(A1,$H$1:$J$10,2,False)),
||||| "",VLOOKUP(A1,$H$1:$J$10,2,False)) can be shortened to
||||| =IF(ISNA(the_rate),"",the_rate) where the_rate is a name with a
||||| Refersto value of =VLOOKUP(A1,$H$1:$J$10,2,False)
|||
||| Doesn't that make formula auditing very difficult?
|||

If you specify a NAME instead of "VLOOKUP(A1,$H$1:$J$10,2,False)" and you
need to find out why the formula (possibly) returns a wrong value, doesn't
it make that process more difficult?


--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk