Need to lookup and return data from a table when 2 lookup criteria are met. Struggling to get formula to work through 2 vlookup questions and return a value if they are both met.
Need to lookup and return data from a table when 2 lookup criteria are met. Struggling to get formula to work through 2 vlookup questions and return a value if they are both met.
If the values to be returned are numeric, you can use SUMIFS
e.g
=SUMIFS(C1:C10,A1:A10,X1,B1:B10,Y1)
where X1 and Y1 contain the values to look up in columns A and B, respectively, and column C contains the number to return.
otherwise
=INDEX(C1:C10,MATCH(1,INDEX((A1:A10=X1)*(B1:B10=Y1),0),0))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
=if(AND(Vlookup() = Value1,Vlookup() = Value2), True, False)
If two values are to be met then using AND function we meet two conditions and then based on it we can give the results
___________________________________________________________________________________________________________________
Please click * to say thank you
Thank you for replies.
The formula needs to find the data line within one table that has 2 exact data (alpha) matches on a line within another table and return an alpha data entry from a column within one of the tables.
Another option.
If your lookup is in sheet2!A2:K100, and you are working on sheet1 with your two conditions in A2 and B2 for example:
Insert a column A in Sheet2, (you can later hide this)
In sheet2 A2 =B2&C2 copied down
Then in sheet1
=VLOOKUP(A2&B2, Sheet2!$A$2:$L$100, 4, FALSE)
returning the 4th column which used to be the 3rd column
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks