lookup function

[san111]

I am trying to fill down a lookup function in a column, however, I do not want the lookup_vector and the result_vector to change. They have been increasing by one when filling down, which I do not want. Only the lookup_value needs to go up by 1 when filling down.

Thanks for any help you might have.

 

[Aladin Akyurek]

On 2002-09-12 15:06, san111 wrote:
I am trying to fill down a lookup function in a column, however, I do not want the lookup_vector and the result_vector to change. They have been increasing by one when filling down, which I do not want. Only the lookup_value needs to go up by 1 when filling down.

Thanks for any help you might have.

Lock the ranges of interest like in

$A$1:$F$1

 

[san111]

Thanks a million!