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
.