I found this page recently and thought that the Lookup Function described here may be useful for some loungers.

The UDF allows for searching the nth occurence of a value and allows you to collect other details about the find.
See Excel Lookup nth Occurrence/Instance for details.