closest match
Thank you
macropod wrote:
Hi sandip,
Try:
=IF(B1-INDEX(A$1:A$100,MATCH(B1,A$1:A$100,1))<OFFSET(INDE X(A$1:A$100,MATCH(B
1,A$1:A$100,1)),1,0)-B1,INDEX(A$1:A$100,MATCH(B1,A$1:A$100,1)),OFFSET(I NDEX(
A$1:A$100,MATCH(B1,A$1:A$100,1)),1,0))
Cheers
--
macropod
[MVP - Microsoft Word]
|