Which lookup tool to return multiple pieces of info from multiple cells

**Trueman_86** · 07-02-2010, 08:36 AM

Hi Everyone,

Please see attachment above for a breakdown of the problem. I would like a list box or similar to populate some fields. The problem is that the column which is being used to populate the listbox is made up of Tutor names. These tutors have several students who they are accountable for. I would like a list box which shows all of the Tutor Names however does not dupilcate them, however looks at all of the fields where that tutor is responsible for. (Please do see the attachment, as this may sound ridiculous).

Thanks in advance, any help is more than appreciated.

Regards.

**Trueman_86** · 07-04-2010, 04:22 PM

Hi Everyone,

Please see attachment above for a breakdown of the problem. I would like a list box or similar to populate some fields. The problem is that the column which is being used to populate the listbox is made up of Tutor names. These tutors have several students who they are accountable for. I would like a list box which shows all of the Tutor Names however does not dupilcate them, however looks at all of the fields where that tutor is responsible for. (Please do see the attachment, as this may sound ridiculous).

Thanks in advance, any help is more than appreciated.

Regards.

Attached Files
File Type: xls Help Needed.xls (109.0 KB, 4 views)

**martindwilson** · 07-04-2010, 05:09 PM

title looks ok but i suspect you haven't sent Roy a pm but
suggest

Did Not Start is placed in both columns rather that
Did Not Start/ withdrawn
put a unique list of tutor names as in col H
and hide the linked cell(its now in a2)
then perhaps this will do