Vlookup transpose

[hudson andrew]

Hi all,

I have two series of numbers . in column " A " I have code and in column B I have its corresponding reference numbers.

is there any possible way I can vlookup and get my reference numbers in one cell like my example attached .

Regards,
Hudson

[southward]

Hi Hudson,

Yes, this can be done with a User Defined Function.

This link provides and explanation and example.

https://www.extendoffice.com/documen...-one-cell.html

Hope this is helpful.

Cheers

[JohnTopley]

Re Southward posting: modified to add delimiter e.g. "/"

Please Login or Register  to view this content.

=MYVLOOKUP($A$2,$A$2:$B$9,2,"/")

[hudson andrew]

This is excellent .. thank you so much ... this is very dynamic of this will helps me in doing my work very easy ..

rather I need very simple one ..

[FDibbins]

This is excellent .. thank you so much ... this is very dynamic of this will helps me in doing my work very easy ..

rather I need very simple one ..

Sorry, are you saying that this has answered your question, or that you still need more help?

[hudson andrew]

this was addressed my issue resolved and I am satisfied with john reply ... I am looking if we can do the same thing with excel function rather than VBA ....

[AlKey]

this was addressed my issue resolved and I am satisfied with john reply ... I am looking if we can do the same thing with excel function rather than VBA ....

It can be done with excel formula but it would require to have an Office365 subscription with (free) Office 2016). There are new functions in Office 2016 such as TEXTJOIN and CONCAT that will allow you to do just that.