Lookup (V or H) are for values, Anything for Text?!

[Mike]

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

 

[Harald Staff]

Hi Mike

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

HTH. Best wishes Harald

 

[Mike H]

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

 

[Chip Pearson]

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]

 

[Dave Peterson]

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.