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

Hi Mike

Text is value and value is whatever, no problem. VLOOKUP and HLOOKUP finds
text.

HTH. Best wishes Harald

"Mike" wrote in message
...
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

Mike,

V and HLookup will lookup whatever you specify as the lookup value and
likewise return either text or numeric data from the lookup range.

If you mean you want the lookup to return a numeric value after it finds
text then that's probably dooable with some combination of formulae but you
will need to be more specific.



Mike

"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
.

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

Maybe you're not used to specifying the 4th parm.

=vlookup(a1,sheet2!a:e,4,false)

That false (or 0) tells excel to look for an exact match.

And it works with either text or numbers.

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

--

Dave Peterson