The challenge is to use VLOOKUP function, one of the lookup and reference functions. You should use VLOOKUP when you need to look in a single row or column and find a value from the same position in a second row or column. More info in the attached PDF.
Post your working excel vlookup function spreadsheet as a reply to this post.
For this challenge I submitted the following:
