aimatarv
05-05-2016, 05:38 AM
Please provide some insight on this issue I am having: In the image you will see the word "vlookup" in column "J". That is where I need the vlookup formula to be. The first "vlookup" should read the formula:
=VLOOKUP($B14, 'Table 1'!$B$10:$P$47, 15, FALSE)"
the second one in row 21 would read "=VLOOKUP($B21, 'Table 1'!$B$10:$P$47, 15, FALSE)"
So essentially the only thing that is changing is the lookup value which is changed by the range. The column is staying the same however the row is not.
Thing to note:
There are more than 1 associates, in fact there are 200+ and it varies so whatever is on the screen will not be the same week-to-week.
I tried to write the the vlookup formula in a string in vba within a loop, however when it comes to factoring in the row variable I run into issues. I tried to concatenate but I quickly found out I con-cate-not (sorry for bad pun :( ).
16097
=VLOOKUP($B14, 'Table 1'!$B$10:$P$47, 15, FALSE)"
the second one in row 21 would read "=VLOOKUP($B21, 'Table 1'!$B$10:$P$47, 15, FALSE)"
So essentially the only thing that is changing is the lookup value which is changed by the range. The column is staying the same however the row is not.
Thing to note:
There are more than 1 associates, in fact there are 200+ and it varies so whatever is on the screen will not be the same week-to-week.
I tried to write the the vlookup formula in a string in vba within a loop, however when it comes to factoring in the row variable I run into issues. I tried to concatenate but I quickly found out I con-cate-not (sorry for bad pun :( ).
16097