DRJD
08-13-2008, 07:20 AM
Hi
Although this isn't strictly a VBA question, I do want to use it in a VBA project, so I apologise if this is in the wrong place.
I want to use a vlookup to lookup some data, but the table array is arranged in such a way that the value which I want to return is to the left of the lookup value.
Is there any way to use a vlookup, where the lookup value is not the leftmost column of the table array?
Thanks
Although this isn't strictly a VBA question, I do want to use it in a VBA project, so I apologise if this is in the wrong place.
I want to use a vlookup to lookup some data, but the table array is arranged in such a way that the value which I want to return is to the left of the lookup value.
Is there any way to use a vlookup, where the lookup value is not the leftmost column of the table array?
Thanks