hi there i have this table where all the user will input the data
TABLE 1
<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
<tbody>
</tbody>
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>