Originally Posted by Spencer101

Have a look at the attachment. Does this clear things up?

It would be a case of just a straightforward VLOOKUP if your C and D columns were the other way round, but as they're not I've used CHOOSE to do a "left lookup".

Let me know if you need any of it clarified.