Hi Friends
I need your help again..
In attached sheet, I am trying to enter a formula in column L on the basis as below:
If column I is less than 3, then leave Column L blank
If column I is => 3, then if column B is <= 3, then vlookup "3" from Column B against Same Month sales in column C and return the value in Column L
If column I is => 3, then if column B is > 3, return the same value of column G of same row.
In attached sheet, In column L I have entered formula, it is giving some correct result and somewhere it is showing wrong results. I have mentioned my remarks in column M to describe that what is the desired results against each row.
Kindly check and help me to rectify the formula is column L.
Thanks in Advance.
=======================
Question is also posted on below link but no response.
https://www.excelguru.ca/forums/show...ple-Conditions
Bookmarks