+ Reply to Thread
Results 1 to 4 of 4

Lookup multiple and different criteria on multiple worksheets

  1. #1
    Registered User
    Join Date
    03-19-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    11

    Lookup multiple and different criteria on multiple worksheets

    So I am trying to pull data f
    Last edited by phasesmu; 03-20-2014 at 08:40 AM.

  2. #2
    Registered User
    Join Date
    03-19-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Lookup multiple and different criteria on multiple worksheets

    By the way, I only have Excel 2003.

  3. #3
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: Lookup multiple and different criteria on multiple worksheets

    Maybe this one?
    I amn not sure actually
    Sheet1 J2 cell
    =IF(ISERROR(INDEX(Sheet3!$A$1:$A$217,MATCH(1,(B2=Sheet3!$B$1:$B$217)*(Sheet1!C2=Sheet3!$C$1:$C$217)*(D2=Sheet3!$E$1:$E$217)*(Sheet1!F2=Sheet3!$D$1:$D$217)*(Sheet1!H2=Sheet3!$G$1:$G$217)*(Sheet1!I2=Sheet3!$H$1:$H$217),0))),"",INDEX(Sheet3!$A$1:$A$217,MATCH(1,(B2=Sheet3!$B$1:$B$217)*(Sheet1!C2=Sheet3!$C$1:$C$217)*(D2=Sheet3!$E$1:$E$217)*(Sheet1!F2=Sheet3!$D$1:$D$217)*(Sheet1!H2=Sheet3!$G$1:$G$217)*(Sheet1!I2=Sheet3!$H$1:$H$217),0)))
    Hit ctrl+shift+enter after pasting
    Appreciate the help? CLICK *

  4. #4
    Registered User
    Join Date
    03-19-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Lookup multiple and different criteria on multiple worksheets

    Unfortunately, that didn't work

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Lookup and sum multiple values based on a single criteria in multiple sheets.
    By paulsanett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2014, 12:18 PM
  2. Replies: 0
    Last Post: 10-16-2013, 12:42 PM
  3. Lookup of multiple criteria across multiple worksheets
    By iladel_08 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2013, 06:37 PM
  4. Replies: 11
    Last Post: 02-07-2013, 02:22 AM
  5. Replies: 1
    Last Post: 07-26-2012, 09:21 AM

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