Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
another issue with vlookup
i have another issue i just came across. the sheet its taking the data also
change i mean the first column looks in sheet name May second column looks in sheet name June. when i copy paste it copies may all over the place. is there a way to change it in the formula. its sounds painful to go in and change the sheet name from may to june for 10000 lines. can someone please help "Stephen" wrote: "Arain" wrote in message ... I wrote a vlookup formula to look for a value in cell reference of sheet two. i copy pasted the formul horizontally. later when it was giving n/a i realized when i copy pasted the vlookup it changed the cell reference from A to B and the C. Is there a way to fix it without going through each cell and changing it back to A. Thanks No need for a macro. Go back to the original cell and change the reference to absolute (A1 becomes $A$1, or whatever). Then copy/paste this as before, and the reference will not change to B, C etc. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
another issue with vlookup
Select the cells/columns you need to change month name to and use Edit |
Replace with the "look in formulas" option. Find "May", replace with "June" "Arain" wrote: i have another issue i just came across. the sheet its taking the data also change i mean the first column looks in sheet name May second column looks in sheet name June. when i copy paste it copies may all over the place. is there a way to change it in the formula. its sounds painful to go in and change the sheet name from may to june for 10000 lines. can someone please help "Stephen" wrote: "Arain" wrote in message ... I wrote a vlookup formula to look for a value in cell reference of sheet two. i copy pasted the formul horizontally. later when it was giving n/a i realized when i copy pasted the vlookup it changed the cell reference from A to B and the C. Is there a way to fix it without going through each cell and changing it back to A. Thanks No need for a macro. Go back to the original cell and change the reference to absolute (A1 becomes $A$1, or whatever). Then copy/paste this as before, and the reference will not change to B, C etc. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
another issue with vlookup
I haven't seen your other post, but if you highlight the cells withthe
formula in (presumably using May!range for the table), then CTRL-H for Find & Replace: Find What: May! Replace with: June! then click Replace All. Hope this helps. Pete On Oct 19, 5:54 pm, Arain wrote: i have another issue i just came across. the sheet its taking the data also change i mean the first column looks in sheet name May second column looks in sheet name June. when i copy paste it copies may all over the place. is there a way to change it in the formula. its sounds painful to go in and change the sheet name from may to june for 10000 lines. can someone please help "Stephen" wrote: "Arain" wrote in message ... I wrote a vlookup formula to look for a value in cell reference of sheet two. i copy pasted the formul horizontally. later when it was giving n/a i realized when i copy pasted the vlookup it changed the cell reference from A to B and the C. Is there a way to fix it without going through each cell and changing it back to A. Thanks No need for a macro. Go back to the original cell and change the reference to absolute (A1 becomes $A$1, or whatever). Then copy/paste this as before, and the reference will not change to B, C etc.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP issue | Excel Discussion (Misc queries) | |||
vlookup issue | Excel Worksheet Functions | |||
VLOOKUP issue | Excel Worksheet Functions | |||
VLOOKUP issue | Excel Worksheet Functions | |||
VLOOKUP ISSUE | Excel Worksheet Functions |