Data match function

[Jazmania]

Hi,

I have one column full of duplicate names, column A.

I have another 2 columns's E & F which contain the unique number and corresponding name to that number.

I want to create a formula which i can put in column B which will match every name in A to the name in F but will enter the value as the unique number.

ie

A1 will contain Joe. E1 = 1 F1 =Joe
When I enter the formula in B1 it will show as 1.

How would I write this as a formula?