Example(s) of what you are trying to do would help you to get a meaningful
reply.

"Nandu" wrote:

till now i was using IF,AND function for comparing text from two different
columns to return a value(number) which is in some other column.
But i am able to use this formula for only about 7 functions,now i hav about
35 functions to be used under same formula.
What can i do for this,can any one kindly send me a formula regarding this.
Can i use LOOKUP and AND functions for same formula.
Please reply me as soon as possible.
Thank u