how do I include a vlookup in this function becuase the answer is correct but it needs vlookup in it.

Event Analysis Event Analysis On the EventAnalysis worksheet, in cell D4. enter a formula that will return Goal Met if the number of registrants for the event meets or exceeds the goal for that event outlined in the cell range G4:H9, otherwise retum Promote Event. Copy the formula down through D9. In Step 8, Use a VLOOKUP to retrieve the goal from the 2nd column of the range G4:H9 based on the EventID in cell C4. Use the result of the VLOOKUP in the logical test of the IF function