Vlookup for a cell with multiple criteria

[AdrianCepa]

I have a spreadsheet which looks like this
[TABLE="width: 407"]
<tbody>[TR]
[TD]in the second spreadsheet (Sheet2) i have a list of names with associated references to them. what id like is these refferences to appear in collumn P seperated by a comma like the names are in collumn O, is this possible?
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]O
[/TD]
[TD="align: center"]P
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"]General Access
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: center"]General Access
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD="align: center"]
[TABLE="width: 407"]
<tbody>[TR]
[TD]Registry Administration, Kumar Ramu, Ubaidillah A Hasan, Amran Jamaluddin, Norizah Hamzah, Amelia Rosdiana Othman, Anne Ong, Salwiyah Jumaah, Noorashikin A Mohd Ali, Nor Hafiza Abizaid
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD="align: center"]General Access
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD]
[TABLE="width: 407"]
<tbody>[TR]
[TD]Registry - Administration, Daryl K Wood, Kumar Ramu, Anne Ong
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Could you clarify what the input (source) is and what the output must be?

 

[AdrianCepa]

For example the refferences for these people in the second spreadsheet are,
Kumar Ramu - H2438223
Ubaidillah A Hasan - H2342342
Anne Ong - H3453498
etc.


I would initially like the output in for example cell P3 to be something like "H2438223, H2342342, H3453498"

 

[Aladin Akyurek]

For example the refferences for these people in the second spreadsheet are,
Kumar Ramu - H2438223
Ubaidillah A Hasan - H2342342
Anne Ong - H3453498
etc.

Where are these? The answer "second spreadsheet" is not sufficient.

I would initially like the output in for example cell P3 to be something like "H2438223, H2342342, H3453498"

How must a formula know which names to pick out?

 

[AdrianCepa]

Sheet called "Sheet2" he first one is "Sheet1" and everything which is spaced out by a comma so every name in the cell as i could take the registry administrion part out. Sorry about this, im new to this forum

 

[Aladin Akyurek]

Sheet called "Sheet2" he first one is "Sheet1" and everything which is spaced out by a comma so every name in the cell as i could take the registry administrion part out. Sorry about this, im new to this forum

Adrian, it's difficult to understand your data and the results you want.

 

[AdrianCepa]

is there a way i could attach a dummy file that would show you what id need?

 

[Aladin Akyurek]

is there a way i could attach a dummy file that would show you what id need?

Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste (To test: Test Here).
Otherwise, the public link to a dropbox ifile s an option, but such is not preferred as a substitute for a description (+sample) directly on the board.

 

[AdrianCepa]

Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste (To test: Test Here).
Otherwise, the public link to a dropbox ifile s an option, but such is not preferred as a substitute for a description (+sample) directly on the board.

Im on a company computer so i am not able to download anything, do you have an e-mail address i could send the file to?

 

[Aladin Akyurek]

Im on a company computer so i am not able to download anything, do you have an e-mail address i could send the file to?

Borders-Copy-Paste doesn't require downloading anything. Moreover, more people would see the problem and try to help.