Try recording a macro when you enter it and then take a look at the result.

"Arain" wrote:

I have no clue how to add this vlookup function to a macro.

The formula is
=VLOOKUP(A6,'[Commissions Master
Summary2007-04-04-08-30-25.xls]Sheet1'!$1:$65536,11,FALSE)

Its working great if I keep copy pasting the formula but I want to take it a
step ahead and automate it.