Hey guys, any help on this macros would be appreciated. I've been stuck on it for 2 days.

I have two sheets:
Find Stock Symbols
Stock & Symbol Data

On the find stock symbols sheet, column B5 and downward will have many company names.
The macros will go through each company name and try to match the same company name on the other sheet "Stock & Symbol Data" (from range B2 downward).

When it finds a match, it should select the matched cell, then offset one cell to the left.
It should use this offset cell's value to equal the value in a corresponding cell in the "Find Stock Symbols" sheet in Column C.


(If it's confusing, please see the attached sample sheet.)
Company Name.xlsm


For x = 5 To LastRowBofF
If Worksheets("Find Stock Symbols").Range("C" & x).Value = "" Then
               
    Set FindResult = Sheets("Stock & Symbol Data").Range("B:B").Find _
(what:=Worksheets("Find Stock Symbols").Range("B" & x).Value, After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False)

    If FindResult.Value = Worksheets("Find Stock Symbols").Range("B" & x).Value Then
    FindResult.Offset(0, -1).Select
        
    Worksheets("Find Stock Symbols").Range("C" & x).Value = Worksheets("Stock & Symbol Data").ActiveCell.Value
    End If
     End If
         
Next x

End Sub