display value meeting 2 criteria?

[Nudie072]

Hi,

I need to display a vaule based on values in 2 different cells. i've been playin with index/match with very little success.

Could someone assit with atthced sample file and below:

in C6 I need to look up and match the values selected in

C2 (Data Validated list) month = selected month eg April
C3 (Data Validated List) Account = Selcted Account eg J8ACC001

Both cells using data validation.

Then return the corrisponding value from table ACC_BUDGET_MONTH in the data tab


in C7 i need to look up and match the values selected in

C2 (data validated List) selected mont eg april
C3 (Data Validated List) selected account eg J8ACC001

Both Cells using data validation

Then return the corrisponding vales from table ACC_SALES_MONTH in the data tab

 

[Nebu]

Hi:

Is this what you are looking for?

Thanks

 

[Hui]

or

C6: =SUMPRODUCT((ACC_BUDGET_MONTH[[April]:[March]])*(ACC_BUDGET_MONTH[ACCOUNT]=$C$3)*(ACC_BUDGET_MONTH[[#Headers],[April]:[March]]=$C$2))
C7: =SUMPRODUCT((ACC_SALES_MONTH[[April]:[March]])*(ACC_SALES_MONTH[ACCOUNT]=$C$3)*(ACC_SALES_MONTH[[#Headers],[April]:[March]]=$C$2))

 

[Nudie072]

Hi:

Is this what you are looking for?

Thanks

Perfect Thank you!!

 

[deciog]

Nebu

Conditional Formatting put this formula = $B6=Results!$C$3 and colored the line, look up goutu, trying to help.

Décio of Brazil translation by Goocle translate