View Single Post
  #4   Report Post  
Max
 
Posts: n/a
Default

Think Dana's suggestion of VLOOKUP is much better, albeit according to Excel
help, the index_num in CHOOSE allows one to select one of up to 29 values
<g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----