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.