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
- NameissahilFeb 08, 2023Copper ContributorHi 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