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

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

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/