Hi,
I want a formula on column E.
If the number on column F matches that on column B, I want the word that is on that line on column A to be on column E.
For example, on E1, since F1 is 107, it matches B6, so word should be Green.
On E2, it will be Sad, E3 will be Sad, etc.
What formula can I use? (Column A is text and Columns B and F are numbers)
<tbody>
</tbody>
I want a formula on column E.
If the number on column F matches that on column B, I want the word that is on that line on column A to be on column E.
For example, on E1, since F1 is 107, it matches B6, so word should be Green.
On E2, it will be Sad, E3 will be Sad, etc.
What formula can I use? (Column A is text and Columns B and F are numbers)
| A | B | C | D | E | F | ||||
| 1 | Happy | 102 | Formula here | 107 | |||||
| 2 | Sad | 103 | 103 | ||||||
| 3 | Green | 104 | 106 | ||||||
| 4 | Red | 105 | 102 | ||||||
| 5 | Sad | 106 | 102 | ||||||
| 6 | Green | 107 | 107 | ||||||
| 7 | |||||||||
| 8 | |||||||||
| 9 |
<tbody>
</tbody>
