Text-to-text equals number
Solved/Closed
Related:
- Text-to-text equals number
- Graphic equalizer free download full version - Download
- Spotify equalizer - Guide
- Aimp equalizer presets - Guide
- Vlc android equalizer - Guide
- Excel sum of column if another column equals ✓ - Forum - Excel
1 reply
TrowaD
Mar 5, 2015 at 11:25 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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