Vlookup for a cell with multiple criteria

[AdrianCepa]

I have a spreadsheet which looks like this

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?

<tbody>
</tbody>

	O	P
1	General Access
2	General Access
3	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 <tbody> </tbody>
4	General Access
5	Registry - Administration, Daryl K Wood, Kumar Ramu, Anne Ong <tbody> </tbody>

<tbody>
</tbody>

 

[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.