Formula to get data from certain table

[rizmomin]

Hello:

I have 2 Tables of data, Table called "HALFTIMENEW" and "DepositTable"
I am trying to add formula in cell H2 in sheet2 as below to bring the value from "HalfTimeNew" Table (cell Value B2 in Sheet2)
I have tried with SumIfs formula as put in cell H2 in sheet2.

In this case result in Sheet2 H2 need to be 2339.68

Please let me know if you have any questions.
Thanks.

[Fluff13]

How about
=SUMIFS(HalfTimeNew[Amount],HalfTimeNew[Date],A2,HalfTimeNew[Dept],"Cash",HalfTimeNew[Store],B2)

[rizmomin]

Hello Fluff13:

I need "HalfTimeNew" part of the above formula to be pulled from cell B2 down as the table name will vary based on cell value in B2.

Please let me know if you have any questions.
Thanks.

Riz

[AlKey]

Maybe this

=INDEX(Sheet1!C:C,MATCH("CASH",Sheet1!B:B,0))

[Fluff13]

In that case how about
=SUMIFS(INDIRECT(B2&"[Amount]"),INDIRECT(B2&"[Date]"),A2,INDIRECT(B2&"[Dept]"),"Cash")

[rizmomin]

Hello Allkey, Fluff:

I am sorry, if there is any misunderstanding.
Please refer to attached file.
I will have number of tables in Sheet1 as shown...Here i have 2 tables "HalfTimeNew" & "HalfTime1".
Table name will be in column B of Sheet2 and we need to use table name from column B data to bring "CAsh" data in cell H2, Sheet2

Let me know if you have any questions.
Thanks.

[rizmomin]

Hello Fluff:

Yes, now you got it, Thankssssssssssssss

Riz

[Fluff13]

You're welcome & thanks for the feedback