Using Multiple Columns in a Lookup to return a single value
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?
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.
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?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1