Datatable Excel 2003

Hi everyone, not sure if this is going to be laughed at or not, I spent a while today trying to get this correct. I have a data table, the rows are fixed. The columns are constantly changing, and I would like my rows to get to that point as well soon enough.

I am currently using If then else statements which pick which cell to use for the column input. When I move to 10 or so variables on either side that seems like too much work to code all 100 if statements. I want to have 2 lookups, that will have the cell reference ie "J6" based upon which 2 variables I want to use for this table displayed in the cell. That vlookup is in cell AG32 for the columns. How do I put this as the column. I tried and all I got was error messages.

Table.Selection. RowInput:= range.(AJ9) ColumnInput:= range.("AG32") does not return what I want normally...any suggestions, obviously this forum really helps people and I greatly appreicate the effort people make.