Compare Values in Different Sheets, then copy corresponding cell if matching (Excel 2013)

For Excel 2013, please...

• FIRST off, I'm looking for a formula solution, not macro or such. Just maybe VLOOKUP, or INDEX... those sorts of simple solutions (Just copy paste on a cell).


• HERE's the problem: I got two Sheets: Sheet1 contains presentation data, Sheet2 (reference) contains reference data.


• Sheet2 has data that's not arranged. It's got data I copy-pasted from an ever-changing source.


• I want to always update Sheet1's data using Sheet2.

Here's what they look like (I'll just mockup superhero names and corresponding values):

I got old/existing data in Sheet1, hence:

Sheet1

Column A           Column B
Daredevil          /me want output here/
Spider-Man         /output/
Cyclops            /output/
Wolverine          /output/
Spider-Woman       /output/
Lockheed           /output/
Warpath            /output/

I got new data in Sheet2, hence:

Sheet2

A   Column B       Column C
     Lockheed      Violet
     The Streak    Red
     Cyclops       Blue
     Warpath       Black
     Wolverine     Yellow
     Daredevil     Red
     Kick-Puncher  Red
     Havok         Violet

• Now, if Sheet1's Column A match with Sheet2's Column B, I want Sheet1's Column B to display Sheet2's Column C, corresponding to the matching value (same row from any cell, but in this case, a cell in Column C);


• 
  

  If there's no match, I want it to display: "whatevs". Below is a sample output I'm aiming for:

  
  

  
  Sheet1
  
  Column A          Column B
  Daredevil              Red
  Spider-Man           whatevs
  Cyclops                Blue
  Wolverine            Yellow
  Spider-Woman      whatevs
  Lockheed             Violet
  Warpath               Black
  
  

I've wasted two working days at this already :'( After that, I've decided I'll let the experts handle this. I can't!

Thank you