Vlookup Question

AidanDanby

Board Regular
Joined
Jan 24, 2013
Messages
152
Hi All,
Is it possible to vlookup to the left of something, ie, 'Vlookup(A3,Sheet1!A:B,-3,false)'
 

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,761
Yes, but not with VLOOKUP...
=INDEX(range_to_return,MATCH(lookup_value,lookup_range,0))
 

Forum statistics

Threads
1,085,546
Messages
5,384,373
Members
401,890
Latest member
Angela7

Some videos you may like

This Week's Hot Topics

Top