# Text-to-text equals number

Solved/Closed
Related:

- Text-to-text equals number
- How to equalize volume of mp3 songs - Guide
- How To Make an Excel Sheet Equal to Another ✓ - Excel Forum
- How to type equal sign in hp laptop - Guide
- How to use AIMP auto equalizer preset - Guide
- 1 percentage is equal to how many paise - Office Software Forum

## 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