Hi

You should use Vlookup function. To know more about how to use this
function please read the below page

http://office.microsoft.com/en-us/as...563201033.aspx

Thanks
Karthik Bhat
Bangalore