Sorry but thats a bit vague. Could you copy paste an example of what you have and what you want?
Hi there - apologies please see sessions below are on one tab and then underneath is the other tab - the second tab lists name of person, session number, course name - i want the session number they have been allocated to on the first tab to pull into the session column on the second sheet - so Jack has been assigned to Sales Session_01 - on the second sheet it has him name and the course Sales and i want the Sales Session_01 to pull into the session coumn - hope that makes sense!
[TABLE="width: 1261"]
<colgroup><col span="3"><col span="4"><col span="2"><col></colgroup><tbody>[TR]
[TD]Sales Session_01[/TD]
[TD]Sales Session_02[/TD]
[TD]Sales Session_03[/TD]
[TD]Marketing Session_01[/TD]
[TD]Marketing Session_02[/TD]
[TD]Marketing Session_03[/TD]
[TD]Marketing Session_04[/TD]
[TD]Fieldwork Session_01[/TD]
[TD]Fieldwork Session_02[/TD]
[TD]Summary Session_01[/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD]Greg[/TD]
[TD]Jason[/TD]
[TD]Mary[/TD]
[TD]Mark[/TD]
[TD]Philip[/TD]
[TD]Joel[/TD]
[TD]Harry[/TD]
[TD]Jack[/TD]
[TD]Jack[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD]Phil [/TD]
[TD]Mark[/TD]
[TD]Harry[/TD]
[TD]Sophie[/TD]
[TD]Sally[/TD]
[TD]Jason[/TD]
[TD]Sophie[/TD]
[TD]Mary[/TD]
[TD]Mary[/TD]
[/TR]
[TR]
[TD]Kate[/TD]
[TD]Jason[/TD]
[TD]Harry[/TD]
[TD]Roger[/TD]
[TD]Phil [/TD]
[TD]Greg[/TD]
[TD]Liam[/TD]
[TD]Sally[/TD]
[TD]Kate[/TD]
[TD]Kate[/TD]
[/TR]
[TR]
[TD]Philip[/TD]
[TD]Karen[/TD]
[TD]Sophie[/TD]
[TD]Kate[/TD]
[TD][/TD]
[TD]Karen[/TD]
[TD][/TD]
[TD]Roger[/TD]
[TD]Philip[/TD]
[TD]Philip[/TD]
[/TR]
[TR]
[TD]Joel[/TD]
[TD]Liam[/TD]
[TD]Sally[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Greg[/TD]
[TD]Joel[/TD]
[TD]Joel[/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD][/TD]
[TD]Roger[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Phil [/TD]
[TD]Jason[/TD]
[TD]Jason[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Jason[/TD]
[TD]Mark[/TD]
[TD]Mark[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Karen[/TD]
[TD][/TD]
[TD]Harry[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Liam[/TD]
[TD][/TD]
[TD]Sophie[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sally[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Roger[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Greg[/TD]
[/TR]
[TR]
[TD][TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Name[/TD]
[TD="width: 64"]Session[/TD]
[TD="width: 64"]Course[/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Kate[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Philip[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Joel[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Jason[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Harry[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Sophie[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Sally[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Roger[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Greg[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Phil [/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Jason[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Karen[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Liam[/TD]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[/TR]
[TR]
[TD]Kate[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[/TR]
[TR]
[TD]Philip[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[/TR]
[TR]
[TD]Joel[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[/TR]
[TR]
[TD]Jason[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[/TR]
[TR]
[TD]Harry[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[/TR]
[TR]
[TD]Sophie[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[/TR]
[TR]
[TD]Sally[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[/TR]
[TR]
[TD]Roger[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[/TR]
[TR]
[TD]Greg[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Phil [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Jason[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Karen[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Liam[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]