Search for data and copy different cell if true

[Headline31]

Here is a breakdown:
Annual Totals sheet contains user id information and a running total of errors
Blank Error sheet contains user id with specific error counts

I am looking for a formula that will perform a search in Column A of the Blank Error sheet based on a user id in the Annual Totals sheet. If that name is found, I need it to copy/paste the correlating Total from Column E to the Annual Total sheet.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[TD]Column C
[/TD]
[TD]Column D
[/TD]
[TD]Column E
[/TD]
[/TR]
[TR]
[TD]User ID
[/TD]
[TD]Week 1
[/TD]
[TD]Week 2
[/TD]
[TD]Week 3
[/TD]
[TD]Total
[/TD]
[/TR]
[TR]
[TD]name1
[/TD]
[TD]5
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]name2
[/TD]
[TD]1
[/TD]
[TD]7
[/TD]
[TD]6
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]name3
[/TD]
[TD]9
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]13
[/TD]
[/TR]
[TR]
[TD]name4
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD]6
[/TD]
[/TR]
</tbody>[/TABLE]

 

[crazydragon84]

not sure if the table you pasted is Annual Totals (I think it is?) or Blank Error, and what the other sheet looks like. sounds like sumifs would work, no?

 

[Headline31]

The table shown is actually Blank Error. The Annual Totals has User ID rows and Monthly columns. I am a little bit newer with Excel so I am not sure how to set up the formula for sure. The one issue that I am coming up with is the user ids are not always in the same row # which would cause issues with the "range" factors of this formula. Unless I am just not understanding.

 

[crazydragon84]

so the annual total you just basically want column A and column E of blank error but in different order?

if so you can just use Sumif(Column A of Blank error, A2 (or whatever cell the name is on Annual Totals), column E of blank error)

 

[Headline31]

I need the sum of columns B+C+D (or column E) for each different name on Blank Error to be moved to the applicable name in Annual Totals. For example with the table above, I need "10" to be the answer to the formula for name1 on Annual Total.

 

[Headline31]

I think I have determined that VLOOKUP or INDEX may work but I am not sure how to lay it out. Again, to clarify based on the table above, I need a formula that will search in Column A for a specific name, and if that name is found, the value in Column E should be returned (the answer to the formula).