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
As I'm quite new to excel there is the probability that I'm missing something quite simple.
Many Thanks
Wobly