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.

1. Click the cell containing the VLOOKUP arguments.
2. Grab the cell handle that displays in the lower right corner.
3. Left-click and drag down the cell handle to cover your column range.

Or, instead of 2. Double click the cell handle and Excel will auto-fill it in where it thinks you want the argument.

Nah, still giving #N/A in all cells, try HARDER Conan!

“I can go in to each cell and press enter which then ‘activates’ the formula…“

Cells are formatted as text ? That’ll stop a formula working until you edit it.

Nope, done that

Have you got the dollar signs in the right places?

Your formula should look something like

= VLOOKUP ( A1, [data range], #, false )

Your data range should probably have $s eg $B$1:$F$13000 but if you have a $ by the A1 (ie, $A$1 OR A$1) in the first bit, that will only check the cell in A1.

check the Excel itself is set to automatic calculation

File – Options – Formulas – Automatic

Reggie Gasket – You are the winner. Award yourself a biscuit. 😀

I’ll duly consider myself bourbonned.

poor, poor conan 😥