title: How to return value from VLOOKUP into a cell?
body: <p>I have the following piece of code for Vlookup. The function works fine but the found out value aint getting displayed in the cell. However if i had a used Msgbox function the found out value is shown. The question is doesnt VLOOKUP result be captured in a cell?</p>
  
  <pre><code>Sub Example_of_Vlookup()
  Dim lookFor As Range
  Dim rng As Range
  Dim col As Integer
  Dim found As String
  Dim lastrowrange As Long
  Dim area As Range
  lastrowrange = [A65536].End(xlUp).Row
  Set lookFor = Sheets("Sheet2").Range("b2")
  Set rng = Sheets("Sheet2").Columns("t:u")
  Set taxRange = Range("f2", Cells(lastrowrange, 22))
  col = 2
  
  On Error Resume Next
  For i = 1 To lastrowrange
  found = Application.VLookup("B2", "T1:U4", 2, True)
  If IsError(found) Then
  MsgBox lookFor &amp; " not found"
  Else
  
  area.Cells(i, 2).Value = found
  End If
  Next i
  On Error GoTo 0
  End Sub
  </code></pre>