I have a set of values in Sheet1 that I need to pull data for each
value from Sheet2. I've tried a simple VLOOKUP, and it will not work,
no way, no how. Yes, the lookup table is sorted ascendingly. I get
errors on about 85% of my rows when I copy the formula down.
Yet, when I copy the value from Sheet1 and paste into the Find and
Replace box to search Sheet2, it finds the value everytime.
What I need is a macro that will will copy and paste the corresponding
data from Sheet2 into Sheet1 in column I.
My lookup value is in Sheet 1, Column C. The lookup table will be
Sheet2! A:B, with the value I need to copy and paste to Sheet1 in
column B of Sheet2.

There has to be a simple set of code to do this--I'm desperate--please
help!

dutty