vlookup with variable range and variable array size

Hi,

I'm having real trouble with VBA. I want to search a table for values in column A and return the values in colum d.

The values in A are changing through the chart.

This is what i have as a test and all I get is it entering the formula and not putting the values called out in the set statments.

Please Login or Register  to view this content.

I would like to be able to have A1:g4 as a variable and b will be cycling....

any ideas?