vlookup in VBA

[ENGinTraining]

I'm somewhat new to the visual basic side of excel. I'm trying to write a program to do a vlookup of data using excel.
This is the statement in excel:
=VLOOKUP(state5_p &"|" &state5_t,'Table A-6E'!A9:F619,3,FALSE)
can anyone tell me how to wright that in basic?

 

[CWatts]

http://www.mrexcel.com/forum/search.php

or

http://www.mrexcel.com/forum/showthread.php?t=59347