Thank you. That is sweet. I have 2 lists with about 20 and about 50
translations. I use the choose method for the shorter and the index
method for the latter, so I have examples of both.

In message of Tue, 4 May 2010
15:12:21 in microsoft.public.excel.programming, ozgrid.com
writes
See this page for different ways.
http://www.ozgrid.com/Excel/cell-lookup.htm
--
Walter Briscoe