Is it possible to pull information within the same table based off of person assigned to work

Hi,

I am trying to pull the information from one group into another group. The scenario which I would like to create is. I have a group with 2 columns, the individual assigned to the the row and a second column which will contain a specific number.

In a new group within the same table, when that individual is assigned, it looks at the above group, sees the name and pulls the specific number through. If un-assigned, the number will disappear.

Is this possible?

Thank you,
Lee.