can LOOKUP function compare text instead of numerical data?

C

cheerboy555

As title.

Can LOOKUP function compare text in cells instead of numerical data?

Thanks much
 
R

RagDyeR

Don't forget though ... data *must* be sorted for accurate returns.

123A
Comes *before*
A123
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"cheerboy555" <[email protected]>
wrote in message

As title.

Can LOOKUP function compare text in cells instead of numerical data?

Thanks much
 
Top