can LOOKUP function compare text instead of numerical data?

  • Thread starter Thread starter cheerboy555
  • Start date Start date
C

cheerboy555

As title.

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

Thanks much
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Type Problem 1
make Excel see a (one digit) number as text 5
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
Index with partial text 1
Exact Match colour 4
Lookup function doesn't work 3
Offset and Small functions with blank rows? 0
Giving Text a Numerical Value 4

Back
Top