Text-to-text equals number
Solved/Closed
Related:
- Text-to-text equals number
- How to make a word equal a number in excel - Guide
- Aimp android equalizer bands number - Guide
- How to enable the equalizer on VLC for Android - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
5 Mar 2015 à 11:25
5 Mar 2015 à 11:25
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
5 Mar 2015 à 12:51
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!!!
6 Mar 2015 à 02:23
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..!?!?
12 Mar 2015 à 12:03
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
17 Mar 2015 à 04:46
Thanks a lot!!
Best regards
Kris