Nested IFS statement

[GcOtt]

Greetings, Im having some trouble returning a value in my IFS statement and am hoping for some help.
I am trying to pull data from one column when a specific data set is present and in addition another column when an employee count is present - Here is what ive got and im getting "NA":
=IFS(A2="Random Text",IF(Master!C2="0-9",240))

Thanks in advance for your help here!

 

[etaf]

hi, sorry - BUT this does not help

whatever etc

As i said we need
So

what are all the possible valid values for A2 ?
what are all the possible valid values for C2 ?

So in a table have the following values for C
0-9,10-99, 11-499,500-1499,1500-4999

Then In another column have
column A are text values ABC company, DEF

The you can do 2 COUNTIF ()
So
=AND ( COUNTIF(Table of C value, C2)>0, COUNTIF(Table of A value, A2)>0 )
then if both those value are present on the Table - it will be TRUE for both conditions
Then use an IF
=IF( AND ( COUNTIF(Table of C value, C2)>0, COUNTIF(Table of A value, A2)>0 ), 240, 0)

 

[GcOtt]

hi, sorry - BUT this does not help

As i said we need
So

So in a table have the following values for C
0-9,10-99, 11-499,500-1499,1500-4999

Then In another column have
column A are text values ABC company, DEF

The you can do 2 COUNTIF ()
So
=AND ( COUNTIF(Table of C value, C2)>0, COUNTIF(Table of A value, A2)>0 )
then if both those value are present on the Table - it will be TRUE for both conditions
Then use an IF
=IF( AND ( COUNTIF(Table of C value, C2)>0, COUNTIF(Table of A value, A2)>0 ), 240, 0)

OK this sounds awesome Ill give it a try thanks again for your help here very much appreciated!