VLOOKUP HELP REQUIRED

hi   I need help calculating the total number of attendees confirmed for an event to using a vlookup (unless there is any other formula I can use). data is as follows: columns A and B have first n...