Thread: VLOOKUP Changing reference cells in autofill
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barry barry is offline
external usenet poster
  
Posts: 116
Default 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.
Reply With QuoteReply With Quote