On Fri, 19 Oct 2007 09:11:00 -0700, jchick0909 wrote:

Long story short, i'm trying to define several vlookup formulas. The vlookup
works, but excel doesnt understand to lookup the cell in the same row, in
column E as the lookup value when trying to define.


undefined formula in cell K80:
VLOOKUP($E80,VLK!$F$4:$H$9,2,FALSE)

when defining this, somehow i need to tell the formula to look up the value
in the cell 6 rows to the left.

TIA!!!

Something like this?

=VLOOKUP(OFFSET(K80,0,-6),VLK!$F$4:$H$9,2,FALSE)

All you have is reference to K80 (the same cell the formula is in) and
offset.

Regards,

B.