First off, Make sure your motherboard can support multi-core processors
I have a computer with an LGA 775 that can only support 1 core, so it's limited to Pentium 4's and Celeron D's
If it does support multi-core, look at a database of Intel's Core 2 lineup, and pick the highest end one that your motherboard can support.