Formula Macro

[silvertable81]

I want to make a macro with a VLOOKUP function, which looks on a char
of cell names, then cuts the cell named in the VLOOKUP, and pastes i
in a cell in the printable range.

Question; How do I make a macro do VLOOKUP. I'm relatively new and hav
only made macros using the recorder

 

[Ken]

Here is the basic code:

Range("C1") = "=VLOOKUP(A1,'WorkBookName.xls'!
$A$1:$B$100,2,FALSE)"