•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