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

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
Hi Mike

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

HTH. Best wishes Harald
 
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
 
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]
 
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.
 
Back
Top