vba - Excel - Check if value exists in a column in another worksheet and return adjacent column -

i have 2 worksheets:

in everyone have column taken email addresses. columns c z full of other data.

in eventbrite have column taken email addresses. column b course

so looking in everyone, column b populated corresponding course

i have tried following in b2 #ref error

=vlookup(a2,eventbrite!a:a,2,0)

please try this:

=vlookup(a2,eventbrite!a:b,2,0)

hope help.

Brazee