CODEWITHSUNDEEP
excelvlookup
Mike Edinger
Mike Edinger

Reputation: 175

vlookup problems with copy/paste

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.

Upvotes: 1

Views: 30156

Answers (4)

Mikael Fangel
Mikael Fangel

Reputation: 11

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

Upvotes: 1

Paul Wu
Paul Wu

Reputation: 71

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

Upvotes: 1

Luis Guicho
Luis Guicho

Reputation: 5

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

Upvotes: -1

msiudut
msiudut

Reputation: 251

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.

Upvotes: 0

Related Questions