Probably a stupid question but is it possible to do a vlookup to the left? i.e.
=vlookup(A1,R100:R200,-1,false)
and pick up the relevant information in column Q.
Probably a stupid question but is it possible to do a vlookup to the left? i.e.
=vlookup(A1,R100:R200,-1,false)
and pick up the relevant information in column Q.
Re: Vlookup Backwards
Hi Timbo,
You should use Offset and Match for this
Re: Vlookup Backwards
There are ways, but not with VLOOKUP
one way would be
=OFFSET(Q100,MATCH(A1,R100:R200,0)-1,0)
Re: Vlookup Backwards
Or may be..
=INDEX(Q100:Q200,MATCH(A1,R100:R200,0))
Re: Vlookup Backwards
Thanks for the options guys.
Tim.
Re: Vlookup Backwards
Not sure if I should be adding something to a more than 9 year old thread, but I have had to struggle a lot every time my data setup changes and I have to literally spend hours and days moving everything around. Also, found a lot of people asking if Reverse Vlookups are possible.
So in the spirit of helping, answer is Yes!
Use this formula:
Credits to Ace_XL at http://www.excelforum.com/excel-formulas…-backwards.html
Detailed explanation as to how this formula works is at http://chandoo.org/wp/2012/09/06/formula-forensics-no-028/
Hope this helps a lot of guys....
Don’t have an account yet? Register yourself now and be a part of our community!