Vlook up Help

[confusedjo]

I currently have a workbook with 2 sheets -

sheet one (event) containing columns:-
Membership No(d cell) Name(e cell) Grade(f cell)

sheet two (data) containing columns with the data
Membership No (a cells) Name(b cell) Grade(c cell)

what i am wanting to do is pull the name and grade information from sheet2 when i enter the membership no in sheet one. I have been able to do this with vlook formula but would like to do this for the whole worksheet without formulas and having trouble writing a code in vba to complete this - any help would be greatly appreicated (totally new to coding).
Any help is greatly appreciated

 

[wigi]

What is the code you have now?

 

[confusedjo]

currently dont have a code (totally new to coding)
the formula i can use to obtain the results is:-
=VLOOKUP(D6,DATA!A1:B200,2,FALSE) this returns the data i require but only for the one cell and i would like to run this for the whole form.

 

[wigi]

Then consider:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count = 1 Then
        If Target.Column = 4 Then
            On Error Resume Next
            Target.Offset(, 1).Resize(, 2) = Sheets("DATA").Columns(1).Find(Target.Text, , xlValues, xlWhole).Offset(, 1).Resize(, 2).Value
            On Error GoTo 0
        End If
    End If
End Sub

 

[confusedjo]

PREFECT!!

If you had the time would you mind explaining the code to me, i understand the formula required but unsure how this is translated to coding.

Thank you so much for your time.

 

[wigi]

At each change of a cell in column D (= 4), the cell that is 1 cell to the right of the changed cell (Target) is taken. That cell and the one next to it (Resize(,2)) are filled with 2 cells coming from sheet Data. There, I do a Find action on column A.

 

[confusedjo]

Thanks heaps works wonders!!!