vlookup problems with copy/paste

28.6k views Asked by At

I have a spreadsheed where I have used the vlookup function. As far as I know, that part is working correctly. However, I want to copy and paste the results of the formula and not the formula itself. Normally I would just paste special- values (and indeed, that's what a google search tells me to do). However, when I try to do that, the only cell that is pasted is the first cell. how can I fix this?

Because I am only using the formula in cells that are blank, would that be a reason that copy/paste isn't working correctly?

Here is the VLOOKUP code that I am using: =VLOOKUP(BE53, $BA$2:$BB$9999, 2, FALSE) and then I drag is down to copy it.

4

There are 4 answers

0
Paul Wu On

Try this: In the SOURCE sheet, copy the range that contains vlookup formula paste special (value) to the same SOURCE sheet (but in different range)

and then copy the pasted values to the DESTINATION sheet (normal copy-paste not paste-special)

a little bit work-around but perhaps it can work

1
Luis Guicho On

Select everything that you need to copy, then just CTRL + C, go to the first cell where u need to paste it and press CTRL + ALT + V and select values then Enter

0
msiudut On

Rather than copy paste, could you just point the cell/database/ppt/whatever at the cells in question?

For example, if vlookup is in Sheet1 A1 and you are copying it to Sheet2 A1, just type "=sheet1A1" into sheet2 A1?

It gets more complicated if you want to put it somewhere else but the principle holds.

0
Mikael Fangel On

Use the "copy" function as usual, but use "paste special" (CTRL + Alt + V) and choose values only when you paste it.

https://support.office.com/en-us/article/Paste-values-not-formulas-12687B4D-C79F-4137-B0CC-947C229C55B9