Try vlookup

http://datapigtechnologies.com/flashfiles/vlookup.html

http://www.auditexcel.co.za/lookupandreference.html

http://www.contextures.com/xlFunctions02.html

VBA Noob