Lookup criteria - digits and letter

  • Thread starter Thread starter cindyk
  • Start date Start date
C

cindyk

Hello !
Having an issue with the organization of the array table. A few of the 7
digit resource numbers - the sort criteria - end with "-C".

0100000
0100000-C
0200000
0200000-C

chrono order isnt working for me, I have tried eliminating the dash, and
putting the "C" items at the end of the chrono .

Does anyone have a suggestion ?
Thanks for your time and expertise !!
 
Cindy,

What is it that you are trying to do? Sort, or use the table in a LOOKUP or VLOOKUP?

HTH,
Bernie
MS Excel MVP
 
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

Need 7 digit number with differnt number of leading zeros 10
How to use Sumifs with vertically and horizontally criterias 1
Lookup 5
lookup options 2
Regex. Digits, Letters and Dashes. what am I doing wrong? 6
Sum / Lookup 9
Lookup multiple criteria for a single result 1
LookUp with Mulitple Criteria 4

Back
Top