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