Hi! Hoping some one can help here..I need to compare a value in one worksheet
and look up a match in another worksheet within the same workbook - where a
match is found I then need to put a code into a blank column on the look up
worksheet.

I have experimented with match and lookup functions without success..will i
need to write a macro..if so any code anyone can share that matches my needs?