Check based on multiple conditions and return value

[ANARK]

Hello There - I have data coming from 2 tables, need to Check based on multiple conditions and return value.

Table1:

CTRY	Lvl	A	B	C
AU	1	30	25	22
AU	2	35	28	22
AU	3	60	40	35
AU	4	100	90	60
ROA	1	25	20	10
ROA	2	30	22	10
ROA	3	40	25	20
ROA	4	60	40	30

Table2:

CTRY	Ctgry	Amt
AU	A	36
AU	C	75
ROA	B	31
ROA	A	29

Expected:

CTRY	Ctgry	Amt	Lvl
AU	A	36	2
AU	C	75	4
ROA	B	31	3
ROA	A	29	1

Current sample formula: if ctry="AU" then (if ctgry="A" and amt>=35 then ....)

Data in Table1 and numbers in fields A\B\C keeps changing, Currently Im using a formula with values fed directly(35 in above sample). Looking for an alternate to take the numbers directly.

[flying008 · Accepted solution]

Hi, @ANARK 

I assume you want to summarize the count  < [Amt] under multiple conditions.

CTRY	Ctgry	Amt	Lvl
AU	A	36	2
AU	C	75	4
ROA	A	29	1
ROA	B	31	3