Formula draging issue

[Ahmed Fawad]

here i am using this formula

=MIN(IF(B2:B917=K2,C2:C917))

this is searching a value in K2 from B2:B917 and give out the min value from C2:C917

so when we drag it down like we need it on 80 enteries

in last last row it becomes .... =MIN(IF(B82:B997=K84,C82:C997))
all search is messed up there....
question is ... how we can make it that B2:B917 and C2:C917 remains same but K series goes up as we drag it down

Thanx
Ahmed

 

[VoG]

Try

=MIN(IF(B$2:B$917=K2,C$2:C$917))

confirmed with CTRL + Shift + Enter.

 

[Domski]

=MIN(IF($B$2:$B$917=K2,$C$2:$C$917))

Have a look at the help on Absolute and Relative references.

Dom

 

[Ahmed Fawad]

Try

=MIN(IF(B$2:B$917=K2,C$2:C$917))

confirmed with CTRL + Shift + Enter.

Great it works fine....

you are an angel .....

Ahmed