Hello everyone,
I'm hoping you can assist me with the issue below. I think it's very simple but i cannot find the solution.
So.
Sheet1 & Sheet 2
Capture.PNG -> in Sheet 1 i have some details
Capture2.PNG -> in Sheet 2 i want automatically to have the values "Brand Name" "Type" "Home away" "Qty" of the details whose Qty is <=1.
I am using an IF function for each cell.
For returning me Brand Name:
=IF(Sheet1!D2<=1;Sheet1!A2;"")
For returning me Type:
=IF(Sheet1!D2<=1;Sheet1!B2;"")
For returning me Home/away:
=IF(Sheet1!D2<=1;Sheet1!C2;"")
and for returning me Qty:
=IF(Sheet1!D2<=1;Sheet1!D2;"")
According to the above, when the value does not meet my criteria (Qty is <=1) it returns me a blank cell which i would like to avoid. In "false" case, i would like to move to the next cell. How can i do that?
Capture3.PNG -> that's what i expect to have as a result.
FYI, the above is just an example. Actually i have many details.
Thank you in advance!!
Bookmarks