"Biff" wrote:

=IF(OR(B4={1,2,3,4}..........
... a little bird told me Biff might be suggesting this <bg

You might be better off using VLOOKUP ..
... and which is exactly the response detailed in the other post <g

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