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!!!