Look up and compare data in the same formula.

Hi Guys, once again i'm asking for your help:
(Excel 2003) I have two sheets, named "source" and "target", in "Target" i have data to be compared columns A to E, i want to look up if the number 147 (just as example) is in a range of data in "source", if it is, then compare A to C and if it is equal then return E. i hope you can help me you have an answer on this. Is for my job, thank you very much Guys