PDA

View Full Version : Solved: Using vlookup if the lookup value is not in the first column



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

Bob Phillips
08-13-2008, 07:54 AM
No, you use INDEX...MATCH

=INDEX(results_range,MATCH(lookup_value,lookup_range,0))

DRJD
08-13-2008, 08:08 AM
Thanks very much.