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