Hey there,
Simplified a bit, my problem is that I am trying to lookup a value from one table to another if two criterias are matching. I am using tables, so the expression gets rather long, but please take a look at the attachment and it should be clear.
As the function is in Danish and I cannot seem to find the Code signs (#) in here anymore, I wont try to paste the code here, cause it would just get messy.
Thanks a lot in advance for your help.
Timo
hi Timo. if the 2nd table has unique values, you could try:
=SUMIFS(Tabel2[Volume],Tabel2[Itemnr],Tabel1[[#This Row],[Itemnr]],Tabel2[Country code],Tabel1[[#This Row],[Country code]])
or in terms of cell references:
=SUMIFS($L$5:$L$12,$J$5:$J$12,B5,$K$5:$K$12,C5)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Since you aren't referencing any string values, I went with SUMIFS over INDEX(..MATCH(.
=SUMIFS($L$6:$L$12,$J$6:$J$12,[@Itemnr],$K$6:$K$12,[@[Country code]])
Because you're using a table, make the sure absolute references are in place as in my equation.
@benishiryo
Thanks a lot, I tried the first solution and it works perfect.
@daffodil11
Seems to work perfect as well. As tables are still pretty new to me, could you please explain if there's any difference between [@[Country code]] and [@Country code]. Cause you have both types in your code?
I noticed that F4 doesn't put in the references, so wasn't sure how that works with tables..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks