Vlookup w/ VB

[Guest]

Hello,

I have 2 worksheets like this:
Worksheet A Worksheet B
Row # Column A Row # Column A Column B
1 Paid 1 Paid
$100.00
2 Paid 2 Paid
$50.00
3 Paid 3 Paid
$80.00
4 Paid 4 Paid
$100.00
5 Paid 5 Paid
$100.00
I need to do a Vlookup with VBA of column A in WK A with column B in WK B
Thanks,

 

[Don Guillett]

on a line in the vbe>type vlookup>touch f1 key to get explanation of how to
use functions in vba