Forum Discussion
Ayappan007
Dec 07, 2022Copper Contributor
Need to add 2 columns based on 1 lookup
Hi ,
I have a lookup table .
| C1 | C2 |
| PE | Data1 |
| PE | Data2 |
| PE | Data3 |
| PAP | Data4 |
| PAP | Data5 |
| PAP | Data6 |
| PAP | Data7 |
| **bleep** | Data8 |
| **bleep** | Data9 |
I have sharepoint list .there i want to add this as 2 column - C1 should show PE,PAP,**bleep** and C2 should show the data based the C1 selection
Example : C1 is PE then C2 should show Data1,2,3
No RepliesBe the first to reply