Copy VLOOKUP Formular but only change the Lookup_Value.

[Celtic_Avenger]

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

 

[mangesh_yadav]

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

 

[Frank Kabel]

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 >" <<[email protected]>
schrieb im Newsbeitrag
news:[email protected]...