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