G GN0001 Member Oct 30, 2012 #1 I enter my VLookUp in one cell. When I drag the cell to copy, it only copies the value of firt cell. Please help me with this. GGGGG
I enter my VLookUp in one cell. When I drag the cell to copy, it only copies the value of firt cell. Please help me with this. GGGGG
Debraj Excel Ninja Oct 30, 2012 #2 Hi 5G.. Is this still same after saving the book..!!! or after pressing F9... Please check your calculation Mode.. I guess, it was Manual.. Regards, Deb
Hi 5G.. Is this still same after saving the book..!!! or after pressing F9... Please check your calculation Mode.. I guess, it was Manual.. Regards, Deb
G GN0001 Member Oct 30, 2012 #3 Yes, before I read your answer, I fount that out, but thank you very much for your answer. GGGGG