formula not yielding value from vlookup

All -

I had posted a query and got that resolved with help of excellent members of this group.

http://www.excelforum.com/excel-prog...-new-post.html

I implemented the solution suggested but below piece of code is not putting the value out of vlookup. The column is populated with "#VALUE!". I have to press CTRL+SHIFT+ENTER in order to have the results populated.

With Range("B2")
    .FormulaR1C1 = "=VLOOKUP(lower(RC[-1]),trim(lower('Team Detail'!R2C2:R200C5)),2,0)": .Resize(k).FillDown
End With

Can anyone suggest what is the reason and what could be done to resolve it?