geoffcraver
New Member
- Joined
- Aug 14, 2008
- Messages
- 8
Hello,
I'm working on a macro that performs vlookups. The issue I have is that both the lookup value and table array needed for the vlookup will be variable lengths every time.
So if I have a 'Summary' tab where my lookup value starts in A2, how do I stop the vlookup when it hits a blank cell in column A?
Also how do I create a dynamic range for the table array on the 'data' tab?
Thank You
I'm working on a macro that performs vlookups. The issue I have is that both the lookup value and table array needed for the vlookup will be variable lengths every time.
So if I have a 'Summary' tab where my lookup value starts in A2, how do I stop the vlookup when it hits a blank cell in column A?
Also how do I create a dynamic range for the table array on the 'data' tab?
Thank You