[SOLVED] Use VBA to use Vlookup across two workbooks

[Wraithxiv]

I have two separate workbooks, the first has a list of names starting if F2. The second workbook has a list of names starting in A1 to perform the vlookup. What I would like to do is use VBA to create a macro to lookup the names in workbook1 F2 in workbook2 A1 and if a match is found to return "CUS" the working vlookup I used in the sheet looks like:

The sheet name I used this formula in is call "test".

Even though this isn't VBA code, I thought I would put it in tags just in case.

=IF(VLOOKUP(F2, [Book1]Sheet1!$A$1:$A$2224,1,FALSE)=F2,"CUS","")

If we can convert this to work in VBA that would be great. I have tried putting

Application.WorksheetFunction. in front of it.

Thanks in advance!