returning Specific Text

I have a spreadsheet with a few thousand rows. I need a formula that returns the information (it is text) from column D if the number in column B matches what I am looking for. I know how to do this with numbers and SUMPRODUCT but not with text.

I have attached an example. For instance i will have a seperate spreadsheet where I will want to return the infromation from column D (WINTERS) if the cell equals "1111"


Thanks for the help.