Lookup a value and modify a value x columns to right.

[Gashmore]

The application is a simple sailboat race scoring worksheet. I have a table of sail numbers (in ascending order), boat names and other data such as race class and handicap times. I need to be able to do is, as a boat crosses the finish line, enter a sail number in an input field and on exiting that field 1) look up the sail number and place the current time in a field several columns to the right.

I have the event trigger working but what I need now is sort of a VLOOKUP that puts a value rather than returning a value.

[macropod]

A formula can't modify another cell - you'd need a macro for that. However, to code such a macro, we'd need to know more about the workbook structure. Can you attach a workbook to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.