VLOOKUP Changing reference cells in autofill

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.
 
T

Trevor Shuttleworth

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

Regards

Trevor
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and Conditional Formatting 1
Vlookup, Column Index Num and Autofill 9
Use vlookup within offset? 4
vlookup table_array reference listed in another cell 2
vlookup error 3
second question - vlookup table_array reference listed 1
increment cell reference in a formula 3
remove error value when formula exists for empty cells 2

Top