Hi sampath
Please see the file attached. The desired output is on column E for 4 examples. This of course requires you to maintain the auxiliary table that has all the conditions somewhere on your file.
Also the formula might be a bit bigger then necessary so if anyone wants to step in and make it simpler, be my guest
BR,
Hello Deepak,
Thanks for your clarification, I need to know some more clarification about this formula.
Copied this formula and using in another cell, It is not working.
When copied this formula, I am not able to copy with {} symbol.
Kindly solve this issues.
Regards,
Sampath.S