VLOOKUP Changing reference cells in autofill

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to fill a column with this formula

=IF(ISNA(VLOOKUP(B6,Materials!B7:C50,2,FALSE)),0,VLOOKUP(B6,Materials!B7:C50,2,FALSE))

the autofill changes the B7:C50 in each reference and I'd like to keep it
the same all the way down the column.
 
=IF(ISNA(VLOOKUP(B6,Materials!$B$7:$C$50,2,FALSE)),0,VLOOKUP(B6,Materials!$B$7:$C$50,2,FALSE))

Regards

Trevor
 
Thanks, I appreciate your help.

Trevor Shuttleworth said:
=IF(ISNA(VLOOKUP(B6,Materials!$B$7:$C$50,2,FALSE)),0,VLOOKUP(B6,Materials!$B$7:$C$50,2,FALSE))

Regards

Trevor
Click to expand...
 
Back
Top