Matching cell values found in two columns

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.

Please take a few minutes to re-read the forum rules, and then amend your thread title accordingly.

Thanks.

Hi,

no macro required, just a simple VLOOKUP with error checking.

=IF(ISERROR(MATCH(C2,$A$2:$A$500,0)),0,VLOOKUP(C2,$A$2:$B$500,2,FALSE))

the formula checks if the value in cell C2 exists in column A. If it does not exist, the MATCH function will return an error, and a 0 will be returned in the cell. If the MATCH does not produce an error, the value has been found and VLOOKUP kicks in to return the value in column B on the row that the search value was found.

hth

Alternatively - use a SUMIF

F2: =SUMIF($A$1:$A$1000,$E2,$B$1:$B$1000)
copied down