"Niek Otten" wrote
But if the numbers are always 1-28 and 29-56, you might as well use
=IF(K14<=28,INDEX(B7:AC7,1,K14),INDEX(B9:AC9,1,K14-28))

Much neater, Nick, thanks !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----