The column is already determined and is stored in a seperate cell on the same
row as the look up reference. The distance between the two columens (look up
and return data) are the same distance in all cases.

Biff

"barry houdini" wrote:

Hello Biff

What, exactly, determines the lookup column and/or the column to
return data from? Is the distance between these two columns fixed,
e.g. will the value to be returned always be in the column immediately
to the right of the lookup column (or 2 columns to the right) or is
that also variable?