Forum Discussion
About excel function
Hi
I just want to fetch data from one sheet to another sheet with certain conditions and I am currently using if function but here is a thing is I just want only fetch data if conditions are true, if condition is false it should skip this step and fetch only true conditions's data.
Or should use another function rather if
Please suggest and guide me.
2 Replies
If you have Microsoft 365 or Office 221, you can use the FILTER function
- Hi Hans
I think you don't get the point I want fetch data from one sheet to another sheet with certain conditions and also only if conditions are true
I have also tried ifs function but in ifs function when conditions are false, it show N/A. I don't even want N/A.
May be you get point this time
And could help me
