Matching cell values found in two columns

[MAN]

I'm wondering if someone can help save me some manual labor. I have some spreadsheets that have 2 columns by as much as 500 rows (with 2 headers). column A has a userid and column B has number of errors (for that userid). I also have a "top 10 agents with the highest errors" that i get from another report in column E. I would like to have a macro that can match the userid in E with the userid in A and place the corresponding value that is in B, in column F. If the userid from E cannot be found in A, a 0 would be placed in column F for that user.


A B E F
0009 5 1400 5
0500 7 1405 0
1400 5 3467 8
3467 8 3490 0
6900 23 1234 6
3460 9
1234 6

Thanks in advance.