Forum Discussion
Nameissahil
Feb 08, 2023Copper Contributor
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, i...
HansVogelaar
Feb 08, 2023MVP
If you have Microsoft 365 or Office 221, you can use the FILTER function
Nameissahil
Feb 08, 2023Copper Contributor
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
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