Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy VLOOKUP Formular but only change the Lookup_Value.
Help Needed.
I want to copy the same formular to about 400 rows in a sheet. When I use the copy paste method I dont want to all the cell reference in the formular to be changed, for example: Cell G9 =VLOOKUP(F9,WorkerData!I5:K404,3,FALSE) Cell G10 =VLOOKUP(F10,WorkerData!I5:K404,3,FALSE) Cell G11 =VLOOKUP(F11,WorkerData!I5:K404,3,FALSE) Cell G12 =VLOOKUP(F12,WorkerData!I5:K404,3,FALSE) In other words I want the Lookup_Value (F9) to change but th Table_Array (I5:K404), Col_Index_Num (3) and Range_Lookup (Flase) t stay the same. I have thought of using three other cells with the three part converted to text, and then re-merging them into the cell I want. For Example: Cell K9 "=VLOOKUP(" Cell L9 "F9" Cell M9 ",WorkerData!I5:K404,3,FALSE)" Then Cell G9 would be =K9&L9&M9 to merge the cells together in th complete formular.....then convert back to general format to run th formular. My question is.............IS THERE AN EASIER WAY.....Maybe with VBA o another formular? Thanks Celtic_Avenge -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy VLOOKUP Formular but only change the Lookup_Value.
As I replied to your earlier post, in this case a slight change i
required Cell G9 =VLOOKUP(F9,WorkerData!$I$5:$K$404,3,FALSE) F9 will change but the array table will not - Manges -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy VLOOKUP Formular but only change the Lookup_Value.
Hi
=VLOOKUP(F9,WorkerData!$I$5:$K$404,3,FALSE) also see: http://www.cpearson.com/excel/relative.htm -- Regards Frank Kabel Frankfurt, Germany "Celtic_Avenger " schrieb im Newsbeitrag ... Help Needed. I want to copy the same formular to about 400 rows in a sheet. When I use the copy paste method I dont want to all the cell references in the formular to be changed, for example: Cell G9 =VLOOKUP(F9,WorkerData!I5:K404,3,FALSE) Cell G10 =VLOOKUP(F10,WorkerData!I5:K404,3,FALSE) Cell G11 =VLOOKUP(F11,WorkerData!I5:K404,3,FALSE) Cell G12 =VLOOKUP(F12,WorkerData!I5:K404,3,FALSE) In other words I want the Lookup_Value (F9) to change but the Table_Array (I5:K404), Col_Index_Num (3) and Range_Lookup (Flase) to stay the same. I have thought of using three other cells with the three parts converted to text, and then re-merging them into the cell I want. For Example: Cell K9 "=VLOOKUP(" Cell L9 "F9" Cell M9 ",WorkerData!I5:K404,3,FALSE)" Then Cell G9 would be =K9&L9&M9 to merge the cells together in the complete formular.....then convert back to general format to run the formular. My question is.............IS THERE AN EASIER WAY.....Maybe with VBA or another formular? Thanks Celtic_Avenger --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP on partial lookup_value | Excel Discussion (Misc queries) | |||
vlookup lookup_value text | Excel Worksheet Functions | |||
vlookup lookup_value | Excel Worksheet Functions | |||
Vlookup(lookup_value) | Excel Worksheet Functions | |||
vlookup:same lookup_value, different returns | Excel Worksheet Functions |