Results 1 to 1 of 1
  1. #1
    3 Star Lounger
    Join Date
    Dec 2009
    Thanked 0 Times in 0 Posts

    adding more options/variables

    Presently I have 2 variables, fine & regular and the following code works.
    =IF(VLOOKUP("zzzzz",F:F,1)="fine",M10+INDEX(C:C, MATCH("zzzzz",F:F))-TODAY(),"Current is regular")
    =IF(VLOOKUP("zzzzz",F:F,1)="regular",M7+INDEX(C:C, MATCH("zzzzz",F:F))-TODAY(),"Current is fine")

    They return a number in 1 cell and a string [either Current is fine [M17] or Current is regular [M21] in another cell.

    If I add 1 or 2 more variables, such as heavy and twin, how would I code for having 3 or 4 variables?
    They would return a number in 1 cell and a string in the other cells. M17, 21, 25, 29. The 3 strings would be the same.
    It would return either
    Current is fine
    Current is regular
    Current is heavy
    Current is twin

    See attached sample.
    Attached Files Attached Files

Posting Permissions

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