IF and OR Function Help Needed|General Excel Questions & Answers|Excel Forum|My Online Training Hub

I am only going to use 5 texts for example. Okay, I have the following table:
A      B      C      D
1      Txt1  3      Txt3
2      Txt2
3      Txt3
4      Txt4
5      Txt5 

When the data shows a number 1-5, it displays the corresponding text.

Since I have 5 values, I have a line for each option.

If the formula is false, it displays false.

Id like to find a formula that selects the range and selects the line automatically that does not read “False”, and displays that text in another cell

   A                                                                 B                                     C           D
1   MODEL#                                                     1                                     1          Txt1
2   WANT NAME DISPLAYED HERE:                     XXXX                               2          Txt2
3                                                               =IF($B$1=$C$1, “Txt1”)          3          Txt3
4                                                                =IF($B$2=$C$2, “Txt2”)         4          Txt4
5                                                               =IF($B$3=$C$3, “Txt3”)          5          Txt5
6                                                                =IF($B$4=$C$4, “Txt4”)
7                                                                =IF($B$5=$C$5, “Txt5”)

Now, I want to take B3:B7 and if #2 is the model number, B4 will read Txt2 and B3,B5,B6,&B7 will read FALSE. I want a formula to look through B3:B7 pick the text that isn’t “FALSE” and display that text in cell B2.

If column B looks like this after the formulas calculate in B3:B7...

Txt1

False

False

False

False

Then, B2 would read Txt1