Compare data in columns of two worksheets and return value if match.

Originally Posted by AB33

Different approach.
The only down side with it is I have to reduce sheet 2 in order to match with sheet1. The other option would be to copy these values in to new row(sheet).

AB33.. thank you for your response.. I will investigate your approach tomorrow when I return to work.

as my preliminary tests here at home seemed to have work, i will test it with more data lines in the morning.

I looked at your code, could you explain how it is working, so that I can learn as well?? it is interresting and I have never used 'scripting dictionary' before..

thank you