Cant paste formulas through cells!

**ben.patterson** · 03-10-2009, 11:52 AM

Hi,

Please can someone help...

'When trying to use @VLOOKUP on certain files returns the text associated with the initial result egg column 4 should be similar to column 2. NB: the formula beneath the text is visible and correct on all cells when a cell is clicked on.

A B C D
NA6 Claire Ryan M-9654-0013-01 Claire Ryan
NA6 Claire Ryan M-9654-0019-01 Claire Ryan
NA6 Claire Ryan M-9537-0191-01 Claire Ryan
NA6 Claire Ryan M-9654-0018-01 Claire Ryan
NA6 Claire Ryan M-9679-0001-01 Claire Ryan
NA6 Claire Ryan A-5294-0101-01 Claire Ryan
NA6 Claire Ryan A-4129-0233-03 Claire Ryan
NA7 Nick Clark P40264 Claire Ryan
NA7 Nick Clark M-9559-1020-04 Claire Ryan
NA7 Nick Clark M-9559-1030-03 Claire Ryan
NA7 Nick Clark M-9559-1032-04 Claire Ryan
NA7 Nick Clark M-9559-1033-04 Claire Ryan
NA7 Nick Clark M-9559-1040-03 Claire Ryan
NA7 Nick Clark M-9559-1060-03 Claire Ryan
NA7 Nick Clark M-9559-1071-04 Claire Ryan
NA7 Nick Clark M-9559-1120-01 Claire Ryan
NA7 Nick Clark M-9559-1130-01 Claire Ryan
NA7 Nick Clark M-9559-1351-01 Claire Ryan
NA7 Nick Clark M-9559-1371-01 Claire Ryan
NA7 Nick Clark M-9559-1382-01 Claire Ryan
NA7 Nick Clark M-9671-1002-01 Claire Ryan
NA7 Nick Clark M-9671-1003-01 Claire Ryan
NA7 Nick Clark M-9671-1004-01 Claire Ryan

The formula reads =LOOKUP(A2120,plnr,5,FALSE), =VLOOKUP(A2121,plnr,5,FALSE) etc....

Thanks for your help in advance

**JBeaucaire** · 03-10-2009, 01:25 PM

That's not a clear as you might have hoped. Perhaps simpler to just post up a sample workbook highlighting the errors and telling us what the result SHOULD have been.

To post a workbook, click on GO ADVANCE, then click the paperclip icon.

**ben.patterson** · 03-11-2009, 09:14 AM

Hi,

Thanks for the response.

Please see the attached.

Try pasting the formula down through the cells in column B.

So TR126128, if you drag the formula down to say row 22. You will notice it does not paste the formula correctly.

However, if you then save the file, the changes are then made correctly!!

Strange one...

Regards
Ben

**JBeaucaire** · 03-11-2009, 12:24 PM

Nope...works fine. The formulas update properly when I copy them down.

**ben.patterson** · 03-12-2009, 04:12 AM

Hi,

Many thanks for the response.

Yes, I have found that on other excel installations this works OK.

However on a number of installations, even fresh installs (inc fully patched) this problem still exists.

Any ideas?