How do I get the same VLOOKUP formula in all cells

[Woblypegs]

Hi, I'm creating a spreadsheet where I need the formula =IF([@Code]="","",VLOOKUP([@Code],'Class Info'!A2:F300,2,0)) to go in every cell from b2 to b3000. When in either copy and paste or select and drag it changes the values in the formula. Is there a way of stopping this from happening. I need what's written above to be in those 3000 cells as it's written.
As I'm quite new to excel there is the probability that I'm missing something quite simple.

Many Thanks
Wobly

 

[DanteAmor]

Hi and welcome to MrExcel!
How about

=IF([@Code]="","",VLOOKUP([@Code],'Class Info'!$A$2:$F$300,2,0))

 

[Woblypegs]

Thank you very much DanteAmor I thought it would be something quite simple but just couldn't get it.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.