VLOOKUP and HLOOKUP can lookup text values and return text values.
They are in no way restricted to numeric data.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]




On Thu, 31 Dec 2009 11:27:25 -0800 (PST), Mike
wrote:

Hi,

I know you can use VLOOKUP or HLOOKUP to search for value and return
whatever.

What if you want to search for text and return value?

Mike