How to place multiple values in another column by selecting one option?

I want to Select one option and auto-fill up the other column.

For example:

| Product Name| Price     |
| ----------- | --------- |
| T-Shirt     | 100       |
| Mobile      | 200       |
| Laptop      | 500       |

Now, i will select Product Name and price will place automatically. To be clear please check the image! and Video

Back to Top