Text-to-text equals number
Solved/Closed
Related:
- Text-to-text equals number
- Sum if less than or equal to ✓ - Excel Forum
- Hiding a cell if value equals X ✓ - Office Software Forum
- How to equalize volume of mp3 songs - Guide
- How To Make an Excel Sheet Equal to Another ✓ - Excel Forum
- How to use AIMP auto equalizer preset - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 5, 2015 at 11:25 AM
Mar 5, 2015 at 11:25 AM
Hi Kriswiberg,
Try the following formula in sheet1 cell B1:
=IF(A1=Sheet2!A1,Sheet2!B1,"")
Best regards,
Trowa
Try the following formula in sheet1 cell B1:
=IF(A1=Sheet2!A1,Sheet2!B1,"")
Best regards,
Trowa
Mar 5, 2015 at 12:51 PM
You were on the right track. I got an error message, but kept to your formula and ended up with this =IF(A1='Sheet2'!A1;'Sheet2'!B1;0)
That makes it count zero until the cells match :-D Thanks a lot!!!
Mar 6, 2015 at 02:23 AM
How can I expand this formula, so that for example, if I have another dropdown box on sheet2, A2, and I want excel to say that Sheet1, A1 should be equal with Sheet2, A1 OR Sheet2, A2..!?!?
Mar 12, 2015 at 12:03 PM
Depending on your language you will have to use either , or ; as separator.
Your new formula would look like:
=IF(OR(A1=Sheet2!A1;A1=Sheet2!A2);Sheet2!B1;0)
Best regards,
Trowa
Mar 17, 2015 at 04:46 AM
Thanks a lot!!
Best regards
Kris