sumifs with multiple tables

[Luc1997NL]

Hello,
I have a question and i hope someone can help me out.
I want to use the indirect function. I already used it in F1. I did =VLOOKUP(E1,INDIRECT(D1),2,0)
Now I want to do it the same way in F3 but now with sumifs or maybe another function? I actually want a value of 18 in F3. How can I do this?
Kind regards,
Luc

 

[Fluff]

How about

=LET(Tbl,SWITCH(D3,"Table1",Table1,"Table2",Table2),SUMIFS(INDEX(Tbl,,2),INDEX(Tbl,,1),E3))

 

[Luc1997NL]

How about

=LET(Tbl,SWITCH(D3,"Table1",Table1,"Table2",Table2),SUMIFS(INDEX(Tbl,,2),INDEX(Tbl,,1),E3))

Thank you for your answer but do you also know the solution for excel 2013? because sometimes I use a older version of excel. I hope you have a formula? Thanks
Kind regards,
Luc

 

[Fluff]

Try

=SUMIFS(INDEX(INDIRECT(D3),,2),INDEX(INDIRECT(D3),,1),E3)

 

[Luc1997NL]

Try

=SUMIFS(INDEX(INDIRECT(D3),,2),INDEX(INDIRECT(D3),,1),E3)

Thanks a lot. You are great! keep up the good work.

 

[Fluff]

You're welcome & thanks for the feedback.