You're welcome !
I used "255" as the width param in the OFFSET
to cover all the cols from col B across to col IV
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"rlchavda" <rlchavda.1s2hq4@ wrote in message
...
Hi,
I have got one answer like
SUM(OFFSET(B1,MATCH(A10,A2:A5,FALSE),0,1,55)) and yours also seems to
be what I was looking for.Thanks
I greatly appreciate both of your help.
Thanks
Raj.
--
rlchavdaPosted from http://www.pcreview.co.uk/ newsgroup access