+ Reply to Thread
Results 1 to 3 of 3

Using Multiple Columns in a Lookup to return a single value

  1. #1
    Registered User
    Join Date
    08-24-2006
    Posts
    7

    Using Multiple Columns in a Lookup to return a single value

    Hi.

    I have two worksheets, and each of the worksheets have 5 of the same columns. I want to take the 5 values (in the 5 different columns) and then check for a match in the other worksheet, and if there is a match, then return a value from a 6th column in the 2nd worksheet.

    How would you do it?

    THanks

  2. #2
    Forum Contributor
    Join Date
    03-15-2005
    Location
    North Carolina
    MS-Off Ver
    2003 & 2007
    Posts
    180
    I'm no pro at this but it appears to work. There has to be a better way though

    =IF(SUM(IF(Sheet1!A1:E1 = Sheet2!A1:E1,0,1)) = 0,Sheet2!F1,"")

    This compares the values in A1 to E1 from Sheet1 to the values in A1 to E1 in Sheet2. If they match, it takes the value in F1.

    It basically sums cells that don't match and checks to see if its > 0. If the sum is 0 (all match) then it returns F1.

    HTH

    Jason

  3. #3
    Registered User
    Join Date
    08-24-2006
    Posts
    7
    Thanks. This won't work for me. The data from one sheet needs to be looked up in the second sheet. I'm trying to take 5 different values from one sheet and then use those 5 values to do a lookup in the second sheet. Can you do a lookup using multiple lookup values?

+ Reply to Thread

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