(A level applied ICT):VBA Cell referencing, VLOOKUP and IF statements in one line

I want to create a code on VBA for a swimming competition.
I want the code to state if a cell in a worksheet says "New Record", It would use a VLOOKUP to look at the name of event besides it and then to replace the new record time ontop of the current record.

Currently, I have

Please Login or Register  to view this content.

Which doesn't seem to work

There are two sheets involved, the "New Record" worksheet which is a hidden worksheet where everything is laid neatly and the "current records 6 lane events" worksheet which is also hidden as this sheet is used to be compared to see if any times have broke the record. the cell B2 is an IF function which defines whether the time for row 2 has broke the record. Cell A2 would be the name of the event. The range of A2:D17 is the full list of the records and row 3 shows the times of the current record and the last C2 is the time which is used to break the current record.

Any help would be appreciated

I fear your threadtitle doesn't meet the forum rules requirements nor matches the content of your post.

Mid(title,instr(title,":")+1) would be better...

If you read it carefully and apply it to your threadtitle; some 'speak' VBA in this forumcorner...