dcsimg
Results 1 to 6 of 6

Thread: [RESOLVED] Vlookup for when there are two criterias

  1. #1

    Thread Starter
    Member
    Join Date
    Jul 2010
    Posts
    50

    Resolved [RESOLVED] Vlookup for when there are two criterias

    I have to match 2 data items to get the rate ....

    please check the attached excell


    When "KG" and the "Item code" in both the tabs matching get the correct rate..
    Attached Files Attached Files

  2. #2
    Member pike's Avatar
    Join Date
    Jul 2008
    Location
    Alstonville, Australia
    Posts
    47

    Re: Vlookup for when there are two criterias

    Hello,
    In cell C5=LOOKUP(2,1/(Report!A$2:A$82=B5)/(Report!$C$2:$C$82=A5),Report!$D$2:$D$82)

  3. #3

    Thread Starter
    Member
    Join Date
    Jul 2010
    Posts
    50

    Re: Vlookup for when there are two criterias

    thanks mate..this is awesome

  4. #4
    Member pike's Avatar
    Join Date
    Jul 2008
    Location
    Alstonville, Australia
    Posts
    47

    Re: [RESOLVED] Vlookup for when there are two criterias

    Hi,
    or
    =INDEX(Report!$D$2:$D$82,MATCH(1,INDEX((Report!A$2:A$82=B5)*(Report!$C$2:$C$82=A5),0),0))
    few different ways

  5. #5

    Thread Starter
    Member
    Join Date
    Jul 2010
    Posts
    50

    Re: [RESOLVED] Vlookup for when there are two criterias

    Awesome..this works too

  6. #6
    Member pike's Avatar
    Join Date
    Jul 2008
    Location
    Alstonville, Australia
    Posts
    47

    Re: [RESOLVED] Vlookup for when there are two criterias

    No worries,, thanks for posting

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width