What's the equivalent code to to Vlookup, but searching down and left, rather than down and right?
Thanks.
I want to find a match on a value which is two collumns prior to my search key.
Printable View
What's the equivalent code to to Vlookup, but searching down and left, rather than down and right?
Thanks.
I want to find a match on a value which is two collumns prior to my search key.
Something like :-
=INDEX(A1:A400,MATCH(z1,C1:C400,0))
Thanks.
Ought to do the job very nicely.