VB Userform Vlookup reference to form data

[schnizzle]

Good Morning All,

Can anyone provide some help? I have a userform where I want to capture data from drop down. When I submit I want to add the data to spreadsheet with additional information using vlookup based on what is submitted in form. This is what I got so far:

erow = ThisWorkbook.Sheets("Raw_Data").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
Cells(erow, 1).Value = CP111
Cells(erow, 2).Value = ActiveCell.FormulaArray = "=VLOOKUP(Cells(erow,1).Value,Scores,2,FALSE)"

I want to display the scoring based on what they put in for a value at CP111. What I keep getting is "FALSE" in column B.

Any direction would be greatly appreciated. I got a little rusty in excel apparently.

Thanks.

Sincerely,

John