ExcelBanter - VLOOKUP Changing reference cells in autofill

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP Changing reference cells in autofill (https://www.excelbanter.com/excel-worksheet-functions/108273-vlookup-changing-reference-cells-autofill.html)

barry

VLOOKUP Changing reference cells in autofill

I am attempting to fill a column with this formula

=IF(ISNA(VLOOKUP(B6,Materials!B7:C50,2,FALSE)),0,V LOOKUP(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.

Trevor Shuttleworth

VLOOKUP Changing reference cells in autofill

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

Regards

Trevor

"Barry" wrote in message
...
I am attempting to fill a column with this formula

=IF(ISNA(VLOOKUP(B6,Materials!B7:C50,2,FALSE)),0,V LOOKUP(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.

Barry

VLOOKUP Changing reference cells in autofill

Thanks, I appreciate your help.

"Trevor Shuttleworth" wrote:

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

Regards

Trevor

"Barry" wrote in message
...
I am attempting to fill a column with this formula

=IF(ISNA(VLOOKUP(B6,Materials!B7:C50,2,FALSE)),0,V LOOKUP(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.

All times are GMT +1. The time now is 02:07 PM.