•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Converting a formula from Sheets to Excel
=if(C1="Apple",index('Sheet1'!C2:C), FILTER('Sheet1'!C:C,'Sheet1'!B:B=C1))
Need help converting this please. Little did I know C2:C would be an issue, much less anything else lol.
If C1 on current sheet is Apple, return all of Sheet1 column C, otherwise return only rows of Sheet1 column C that have Sheet1 column B matching current sheet C1
Thanks!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#AI formula generation techniques
#google sheets
#formula generator
#Excel
#Sheets
#formula
#C1
#Sheet1
#C2:C
#index
#FILTER
#column C
#column B
#return
#match
#issue