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.