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

.. There's a slight advantage in my suggested set-up <g: It enables you
to
enter the paired inputs in Sheet2's cols A and B in any order, and also

the
source data in Sheet1 need not be in ascending sequence [on a per row

basis]
as well ..


And the paired inputs in Sheet2's cols A and B need not be consecutive
numbers either, for example you could retrieve the results for say: 51, 79
or 73, 59 etc
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----