•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
Our take
If you're looking to elevate your spreadsheet skills, understanding how to compare multiple cell values can be a game changer. In this scenario, you want to check if the values in Sheet 1's cells A3 and B3 match the values in Sheet 2's cells A2 and A3, respectively. The formula you’re currently using only checks two cells at once. By modifying it slightly, you can achieve the desired true/false output. Let’s explore how to enhance your formula for better accuracy and efficiency.
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]
Read on the original site
Open the publisher's page for the full experience
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