Multiple look up in excel

S

SoozToad

New Member
Joined
Sep 14, 2014
Messages
4
Dear All
I am not a massively experienced excel user and i am struggling to do a multiple look up and return in excel. I have read some posts but have got myself completely confused - apologies for my lack of experience and understanding! I have a list of people that are assigned to sessions on one sheet and on another sheet i want it to compare the course and the name and draw in the session number against their name - can you help please?

For example I have a Session Registers Sheet where jack is assigned to Sale Session_01 and then i have another sheet called Course sheet which lists name and course and has a column for session - i want it to match the course code and person and pull in the session they on from the Session Registers sheet into the sessions column - there are multiple course and sessions for each person.

Thank you so much in advance for any assistance - it is very much appreciated

Sue
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sort by date Sort by votes
Sorry but thats a bit vague. Could you copy paste an example of what you have and what you want?
 
Upvote 0
steve the fish said:
Sorry but thats a bit vague. Could you copy paste an example of what you have and what you want?
Click to expand...


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]
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Multiple Criteria Look up: Which Function to use?
Replies
2
Views
235
hagia_sofia
hagia_sofia
B
  • Question Question
Fill up non contiguous cells from contiguous cells/clipboard/range
Replies
7
Views
161
Bawltea
B
B
  • Question Question
can I run multiple excel sessions at same time so saving one does not require calculation of other?
Replies
1
Views
363
EFANYoutube
E
FatalLordes
  • Question Question
Excel Online and Reports from Multiple Tabs
Replies
2
Views
345
FatalLordes
FatalLordes
J
  • Question Question
Duplicate Sheets in Excel VBA Project
Replies
1
Views
157
jkpieterse
jkpieterse

Forum statistics

Threads
1,223,894
Messages
6,175,250
Members
452,623
Latest member
Techenthusiast

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top