Hi,
Please provide one example and the result you are looking for

"ecf123" wrote:

can someone help me. I have 4 tables that have four dirrerent conditions.
i need to return one answer if any of the contions are met. This is what if
have done but it did not work.
=if(c1<=2,and(d1<=13,vlookup(worksheet,if(c1<=2,an d(d1=13,vlookup(worksheet,if(c13,and(d1<=19,vloo kup(worksheet,if(c13,and(d119,vlookUp(worksheet, if(c13and(d119,vlookup(worksheet)))))))))))))
--
Thanks ECF