VBA code to create vlookup formula in range

[RoccoM]

Guys:
I have to create a vlookup for a range of cells. I have included an example below.
Here is my problem. How do I account for the formula when I do not know how many rows there will be in my range?
I already created a variable to store my row count, not sure on the rest.
Example: here is my current lookup formula that I created manually. ( obviously I know the range): =VLOOKUP(AE2,$AC$2:$AD$64828,2,FALSE

I copied my data into the same sheet so I can count the rows and store it into a variable. I just need help with using variable in my lookup formula; or is there an easier way?

Example data:

RCD:TYPE	RCD:FUNCTION	Create From	Lookup: Function Field
3C16942A	SWITCH	BLANK-PNL-19INCH-2	CABINET_SUPPLY
3C17111	ETH_SWITCHMODULE	BLANK-PNL-19INCH-2	CABINET_SUPPLY
3C17121	ETH_SWITCHMODULE	BLANK-PNL-19INCH-2	CABINET_SUPPLY
3C17131	ETH_SWITCHMODULE	BLANK-PNL-19INCH-2	CABINET_SUPPLY
3C17203	SWITCH	BLANK-PNL-19INCH-1	CABINET_SUPPLY
3C17203	SWITCH	BLANK-PNL-19INCH-1	CABINET_SUPPLY

<tbody>
</tbody>

Thank you,
Rocco

 

[Fluff]

How about

Sub RoccoM()
   Dim UsdRws As Long
   UsdRws = Range("AE" & Rows.Count).End(xlUp).Row
   Range("AG2:AG" & UsdRws).Formula = "=vlookup(AE2,$AC$2:$AD$" & UsdRws & ",2,0)"
End Sub

 

[RoccoM]

Thank you for the reply. This worked out nicely from me.
Rocco

 

[Fluff]

You're welcome & thanks for the feedback