OK, that worksheet is VERY close to what I need! Do you think you can change two things in the code?

I hate to have you design the whole thing for me, but you're so close with that workbook I figure it will be easy and quick.

1) There will be multiple lookup values in a single column which all need to be looked up individually. (yours only looks up 1 value)
2) The results for each lookup value (if there are any) need to be thrown into the cell to its left. If it finds multiple results, they will be separated by carriage returns but still put within that single cell. (yours puts the results across multiple rows instead of in a single cell)