lookup.JPG

Hi, I want to compare column A (contains all IDs) to column B (contains index of IDs) and place the value from column C (Plant Source) in column D.
So from the example posted cell D11 should have value "B"
What would be the formula I need to enter in D2 ?
Any help much appreciated.
Thanks