+ Reply to Thread
Results 1 to 2 of 2

Lookup:Staff,Contract

  1. #1
    nussbaum
    Guest

    Lookup:Staff,Contract

    I have 3 options, cell A1 contains the words Staff,Contract, a range of other
    texts or it may be blank
    Can Lookup return values for each?
    I have
    = LOOKUP(A1,{"Staff","Contract"," ",""},{1,2,3,""})
    but this is not returning the expected values...I suspect I do not
    understand the necessary order required for this formula ....please advise
    Thank you

  2. #2
    Peo Sjoblom
    Guest

    re: Lookup:Staff,Contract

    You can't lookup a blank cell but you could use this

    =IF(A1="","",VLOOKUP(A1,{"Staff",1;"Contract",2;" ","3"},2,0))


    --

    Regards,

    Peo Sjoblom


    "nussbaum" <nussbaum@discussions.microsoft.com> wrote in message
    news:568B7826-A8E6-4DD1-A432-48326AA579A2@microsoft.com...
    > I have 3 options, cell A1 contains the words Staff,Contract, a range of

    other
    > texts or it may be blank
    > Can Lookup return values for each?
    > I have
    > = LOOKUP(A1,{"Staff","Contract"," ",""},{1,2,3,""})
    > but this is not returning the expected values...I suspect I do not
    > understand the necessary order required for this formula ....please advise
    > Thank you




+ 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