+ Reply to Thread
Results 1 to 3 of 3

Dependency and Lookup

Hybrid View

Andrew.Trevayne Dependency and Lookup 11-19-2010, 01:14 AM
Paul Re: Dependency and Lookup 11-19-2010, 01:33 AM
Andrew.Trevayne Re: Dependency and Lookup 11-19-2010, 01:36 AM
  1. #1
    Forum Contributor
    Join Date
    11-02-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    353

    Dependency and Lookup

    More question here ^^
    I thought I should use lookup on this but Im not quite sure.
    How do i go about this one?

    On my Cell A1, I may have (RX, RWX, RWXD or 0)
    On my Cell A2, What i want is to have a return with following.

    RX = Read and List
    RWX = Read, Write and Execute
    RWXD = Full
    0 = Unknown
    Blank = Unknown

    Thanks in advance.
    Last edited by Andrew.Trevayne; 11-19-2010 at 01:37 AM.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Dependency and Lookup

    Andrew, try this in A2:

    =LOOKUP(A1,{0,"RWX","RWXD","RX"},{"Unknown","Read, Write and Execute","Full","Read and List"})

  3. #3
    Forum Contributor
    Join Date
    11-02-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    353

    Re: Dependency and Lookup

    Paul,
    This is perfect. Thank you very much.

+ Reply to Thread

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