Formula to return data from another cell if two cells matches

[macroos]

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)

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Happy[/TD]
[TD]102[/TD]
[TD][/TD]
[TD][/TD]
[TD]Formula here[/TD]
[TD]107[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Sad[/TD]
[TD]103[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]103[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Green[/TD]
[TD]104[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]106[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Red[/TD]
[TD]105[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]102[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Sad[/TD]
[TD]106[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]102[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Green[/TD]
[TD]107[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]107[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Try:

=INDEX($A$1:$A$6,MATCH(F1,$B$1:$B$6,0))

 

[cooper645]

read post wrong

 

[macroos]

It works as I wanted. Thank you so much for your quick response!

 

[Eric W]

You're welcome!