Hi Jana,

Am Thu, 24 Oct 2013 04:39:41 -0700 (PDT) schrieb
:

E.g. I want to look up values Low, Mid, High. All my words are spelt correctly and I am picking up the right table and selecting the correct column. I also tried playing with formats (General, Text, etc). The only solution that works is if I use numbers rather than words e.g. 1,2,3, rather than Low, Mid, High.

please post your formula


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2