show status on other table

[mark692]

hi there i have this table where all the user will input the data

TABLE 1

name	status	group code
enzo	paid	1
ben		1
danika	not paid	2
lea		2
bing		2

<tbody>
</tbody>

i want data from "TABLE 1" to show in "TABLE 2"

what formula will i use on column "Group Status" to show the status of the Group code given on "Group Code" column. Like the table below

TABLE 2

Group Code	Group status
1	Paid
2	Not Paid
3	N/a

<tbody>
</tbody>

 

[Rummers]

Hi,

Could you please clarify what you are trying to do here, are you trying to get Table 1 "Status" to show Paid/Not Paid/NA if Table 1 "Group Code" is 1,2 or 3?
Or something else?

If it is the status change then this should work...
=IF(OR(C2=1),"Paid",IF(OR(C2=2),"Not Paid",IF(OR(C2=3),"N/A",IF(OR(C2="")," "))))

The last section [IF(OR(C2="")," "] will just return a black cell in the status if the Group Code is also blank.

 

[mark692]

Hi,

Could you please clarify what you are trying to do here, are you trying to get Table 1 "Status" to show Paid/Not Paid/NA if Table 1 "Group Code" is 1,2 or 3?
Or something else?

If it is the status change then this should work...
=IF(OR(C2=1),"Paid",IF(OR(C2=2),"Not Paid",IF(OR(C2=3),"N/A",IF(OR(C2="")," "))))

The last section [IF(OR(C2="")," "] will just return a black cell in the status if the Group Code is also blank.

thank you for your question sir what im trying to do here is to show Paid/Not Paid/N/A on TABLE 2 column Group Status, the data will come from TABLE 1

 

[Rummers]

I See, Well the formula provided before will still work, just paste it into the Table 2 Group Status in the first/highest cell in the column, then change the reference "C6" in each part to be the box of equivalent level in the appropriate Group Code column and you done.

Example...

If just referencing Table 2....

Column A Column B
Row 1 Group Code Group Status
Row 2 1 =IF(OR(A2=1),"Paid",IF(OR(A2=2),"Not Paid",IF(OR(C2=3),"N/A",IF(OR(C2="")," "))))

 

[Rummers]

i see, well the formula provided before will still work, just paste it into the table 2 group status in the first/highest cell in the column, then change the reference "c6" in each part to be the box of equivalent level in the appropriate group code column and you done.

Example...

If just referencing table 2....

Column a column b
row 1 group code group status
row 2 1 =if(or(a2=1),"paid",if(or(a2=2),"not paid",if(or(a2=3),"n/a",if(or(a2="")," "))))

(corrected)