•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
checking 2 cells against value of 3 cells
I'm trying to compare 3 cells value against 2 value and return true/false. I'm able to compare 2 cells, but I'm not sure how do i edit the formula so that Sheet 1 Cell A3, B2 must match Sheet 2 cell A2 and Sheet 1 Cell B3 match Sheet 2 Cell A3
Formula to compare 2 cells
=IF(A3&B3=Sheet2!A2&Sheet2!A3,TRUE,FALSE)
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#no-code spreadsheet solutions
#compare
#cells
#formula
#true/false
#Sheet 1
#Sheet 2
#A3
#B2
#A2
#B3
#match
#values
#comparison
#Excel
#submitted