Comparing worksheet values in two worksheets
 

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?

Comparing worksheet values in two worksheets
 

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?