Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi there,

    I need someone's help, for a formula in result column in Table 1 as attached file, to pick up text in result column in Table 2.

    Thanks and regards


    Indra[attachment=87916:Text Lookup More Than One Condition.xls]
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Indra Kusuma View Post
    Hi there,

    I need someone's help, for a formula in result column in Table 1 as attached file, to pick up text in result column in Table 2.

    Thanks and regards


    Indra[attachment=87916:Text Lookup More Than One Condition.xls]
    try this array formula in C3 (confirm with Ctrl + Shift + Enter)

    =INDEX($C$10:$C$15,MATCH(1,($A$10:$A$15=A3)*($B$10 :$B$15=B3),0))
    Regards
    Prasad

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You could also use:
    =LOOKUP(2,1/(($A$10:$A$15=A3)*($B$10:$B$15=B3)),$C$10:$C$15)
    which does not require array-entering.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for respond guys. I will use Rory's one, because difficult for me to control array stay in formula.

    Once more, people around me will think I am genius! while I keep tell everybodies about this lounge, but seems no one follows, : )

    Rory, hope I can get back to this thread sometime if my brain to slow to understand the logic

    regards

    Indra

Posting Permissions

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