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.
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