NonStopLeo
New member
- Joined
- Oct 6, 2018
- Messages
- 5
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hi Friends
I am new to this forum and need your help.
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.
I am new to this forum and need your help.
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.