But what would be the point of this?

1. By using OFFSET the formula becomes volatile and will slow down a large
workbook.

2. Why not use VLOOKUP(E80,etc

instead of offsetting K80?


--


Regards,


Peo Sjoblom



"Boris" wrote in message
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.