| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup formula copy
I have a Vlookup formula that I want to copy over but everytime I do it
changes...Example: Original formula =VLOOKUP(A4,'P35'!$A$2:$H$83,7,FALSE) when I copy and paste right next to it I get =VLOOKUP(B4,'P35'!$A$2:$H$83,7,FALSE)...Actually what I need is the B4 to remain A4 and if its possible to get the 'P35' to go to 'P36'...I am open to any thoughts or ideas. Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup formula copy
Try this
=VLOOKUP($A$4,INDIRECT("'P"&ROW(A35)&"'!$A$2:$H$83 "),7,FALSE) Mike "Confusicous" wrote: I have a Vlookup formula that I want to copy over but everytime I do it changes...Example: Original formula =VLOOKUP(A4,'P35'!$A$2:$H$83,7,FALSE) when I copy and paste right next to it I get =VLOOKUP(B4,'P35'!$A$2:$H$83,7,FALSE)...Actually what I need is the B4 to remain A4 and if its possible to get the 'P35' to go to 'P36'...I am open to any thoughts or ideas. Thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup formula copy
To keep the cell reference the same you the $ sign to indicate an absolute
reference... =VLOOKUP($A4,'P35'!$A$2:$H$83,7,FALSE) In this case the $ will hold the A constant but allow the 4 to increment. As for incrementing the sheet name there is no built in functionallity to do that. -- HTH... Jim Thomlinson "Confusicous" wrote: I have a Vlookup formula that I want to copy over but everytime I do it changes...Example: Original formula =VLOOKUP(A4,'P35'!$A$2:$H$83,7,FALSE) when I copy and paste right next to it I get =VLOOKUP(B4,'P35'!$A$2:$H$83,7,FALSE)...Actually what I need is the B4 to remain A4 and if its possible to get the 'P35' to go to 'P36'...I am open to any thoughts or ideas. Thanks in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup formula copy
Thanks for both of the responses...very helpful
"Mike H" wrote: Try this =VLOOKUP($A$4,INDIRECT("'P"&ROW(A35)&"'!$A$2:$H$83 "),7,FALSE) Mike "Confusicous" wrote: I have a Vlookup formula that I want to copy over but everytime I do it changes...Example: Original formula =VLOOKUP(A4,'P35'!$A$2:$H$83,7,FALSE) when I copy and paste right next to it I get =VLOOKUP(B4,'P35'!$A$2:$H$83,7,FALSE)...Actually what I need is the B4 to remain A4 and if its possible to get the 'P35' to go to 'P36'...I am open to any thoughts or ideas. Thanks in advance |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup formula copy
Glad I could help
"Confusicous" wrote: Thanks for both of the responses...very helpful "Mike H" wrote: Try this =VLOOKUP($A$4,INDIRECT("'P"&ROW(A35)&"'!$A$2:$H$83 "),7,FALSE) Mike "Confusicous" wrote: I have a Vlookup formula that I want to copy over but everytime I do it changes...Example: Original formula =VLOOKUP(A4,'P35'!$A$2:$H$83,7,FALSE) when I copy and paste right next to it I get =VLOOKUP(B4,'P35'!$A$2:$H$83,7,FALSE)...Actually what I need is the B4 to remain A4 and if its possible to get the 'P35' to go to 'P36'...I am open to any thoughts or ideas. Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy VLookup formula from one spreadsheet to another | Excel Discussion (Misc queries) | |||
| Copy part of VLOOKUP formula? | Excel Discussion (Misc queries) | |||
| How do i copy a vlookup formula into other cells going right | Excel Worksheet Functions | |||
| Vlookup Copy Formula | Excel Worksheet Functions | |||
| Copy VLOOKUP Formula | Excel Discussion (Misc queries) | |||
Linear Mode
