Results 1 to 5 of 5

Lookup formula question:adjacent column

Threaded View

  1. #1
    Registered User
    Join Date
    10-31-2006
    Posts
    61

    Lookup formula question:adjacent column

    I have a column with 11 different numbering schemes that go from 736466.01 through 736466.11 In the group from 736466.01 through 736466.07 I need to have the adjacent column look to those cells and if it finds 736466.01-.07 return "CM" if it is 736466.08-.11 I need it to return "TC". I created the formula below but it doesn't like something I have done unless I change the format of the 736466.xx to text. Anything other than 736466.01-.11 should return a "null" or "void" Can you help me improve this formula, or show me a better way of creating it?

    Thanks,

    Chris

    =LOOKUP(E2,{"736466.01","736466.02","736466.03","736466.04","736466.05","736466.06","736466.07","736466.08","736466.09","736466.10","736466.11"},{"CM","CM","CM","CM","CM","CM","CM","TC","TC","TC","TC"})
    Last edited by waternut; 10-01-2009 at 09:14 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1