Results 1 to 5 of 5

LookUp with Mulitple Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2005
    Posts
    19

    LookUp with Mulitple Criteria

    I am trying to look up values based on three criteria Area, Item Number and Year.

    The data is organized in 18 columns (Area, Item, Year (3 others not relevent) and then 12 Months) and 200 + rows (which can grow each month) the rows can be different years but same Item and Area.

    I want to pull out the numbers from 2006 only.

    I have tried;
    =IF((AND($A11=$B$4,$G11=2006)),VLOOKUP($U2,$C$14:$S$23,6,FALSE),0) references are not correct if looking at attachment
    and Index Match function as an array and can't get it to work.

    I could just delete 2005 data but the raw data comes formatted the same every month.

    A slice of the data is attached.

    Any help would be apprciated.
    Attached Files Attached Files

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