Yeah, it's more fun just to mock you . No, seriously, topgear; what I said about replacing D2 with B2 was right as far as it went, but it didn't go far enough; I didn't notice at first that there was another problem too. Take a look at the formula in Serge's first post, in that Code box; it used my D2/B2 substitution but also corrected the other error too. I think that should work for you.

Having paused to make that crack about mocking you, let me back up and reiterate what I said about your having to think about this. I accept that you're confused, really I do; but while you may have thought about it, you haven't put any of your thoughts into words, explained what you think should happen and what's happening instead, asked what the parts of the VLOOKUP function do, or anything else.

If you're willing, even if Serge's formula works for you, maybe it would help to go over a VLOOKUP that isn't part of your assignment, talking about each piece of it so you'll be comfortable with it next time. VLOOKUP is one of the functions I use a lot in Excel, and I wouldn't be surprised if you do too; so it's well worth spending some time on to learn it well.