[Closed] Excel help - again

Now then,

I'm trying to copy a formula (vlookup) but it's displaying the value of the copied cell in all the cells pasted into? I can go in to each cell and press enter which then 'activates' the formula but I've 13000 lines to get through. Buggering sod, tried all sorts saving in a new workbook, changing type of workbook pasting values of the orginal data. Doing me noggin in now.