"starguy" wrote:
thank you Max I will try to understand it because its a lengthy
formula. however thanks for working.

You're welcome. Pl test it out at your end.

The "lengthy" formula is essentially an extension of the earlier,
with nested IFs used to iterate the checks/returns through
all 4 columns that inputs are likely (in cols E,G,I,K),
with corresponding returns (from cols F,J,H,L)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---