I want to vlookup from the rightmost column of the range

[CEN7272]

I would like to lookup something in the right most column and return the contents of a cell to the left of it. I figure that I could do an offset to go to the left, but I don't know how to lookup sometihng and just return the cell reference (to plug into the offset formula) Maybe I'm going about this wrong or missing something, because it seems to me that this shouldn't be as difficult as I'm finding it to be.

-Clay

-Clay
claysdays.blogspot.com

 

[SkipVought]

Clay,

Can't VLOOKUP, but you can get the job done using 2 functions:

If you're looking up in column N and returning a value from column M and the lookup value is in A1...
[tt]
=INDEX(M:M,MATCH(A1,N:N,0),1)
[/tt]
Match returns the offset row in the range and Index looks up that row,column in the other range.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}