sverrie
10-16-2017, 01:07 AM
Hello,
I have in excel a datasheet with data in column J. In Column L:Q are date which should be found with a VLOOKUP.
In Column J is new data. As sample J10 is new data, and this data should be found in L2:Q9. The range of the old data is always in L:Q, but not always in row 2:9 but sometimes also in row 2:15 as sample.
How can I create a VBA formula with this dynamic table range? See picture below
The formula should lookup the new data in J in the old data range L:Q
20663
I have in excel a datasheet with data in column J. In Column L:Q are date which should be found with a VLOOKUP.
In Column J is new data. As sample J10 is new data, and this data should be found in L2:Q9. The range of the old data is always in L:Q, but not always in row 2:9 but sometimes also in row 2:15 as sample.
How can I create a VBA formula with this dynamic table range? See picture below
The formula should lookup the new data in J in the old data range L:Q
20663