Loop question

Hi Guys


I am struggling on some VBA code to put a value in column based on the cell cell value...

I would like the code to loop through Column A from cell A5 until it finds a blank cell and then stop. If it comes across a value which is in the table in Column H it will to assign the value in Column I to Column C. Pretty similar to a vlookup....


I hope this makes sense.. I have attached a spreradsheet which may help...

Any help would be great


Thanks

Try this code it works on that example book you posted

Please Login or Register  to view this content.

hope this helps,

Jon

its funny how many mays a problem using code can be solved and the competley difference approaches!

fantastic... thanks everyone ;-)