Vlookup - going left! (resolved)

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.