give an example of what you want. vlookup or hlookup should work depending
on what you mean by "Blank column"

"DesparateDave!" wrote:

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?