Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copied info from Excel worksheet, but pasted info won't work in fo
I am very familiar with VLOOKUP but am having problems cutting and pasting
correctly. I copied info from an excel worksheet (on a separate file) to my current worksheet to use a reference. A second worksheet has the VLOOKUP formula, but they aren't working. However, I find if I re-type the info in just the cell it's searching on in the worksheet that has the formula, it works. I've tried recopying the data and pasting as value. My only other option is to retype every stinking line. Can anyone suggest anything to help? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop info from being pasted into a cell that has a drop dow | Excel Worksheet Functions | |||
Can I retrieve info from a file/wksht I copied over in Excel? | Excel Discussion (Misc queries) | |||
Password protection of worksheet when copied and pasted. | Excel Worksheet Functions | |||
How do I protect a worksheet from being copied & pasted? | Excel Discussion (Misc queries) | |||
Create form that can't be chg'd but info can be copied/pasted? | Excel Discussion (Misc queries) |