show values by input numbers (seperated by comma)

Hi,

How can i show values by input random numbers.

For example

Apple = 1
John = 2

When i type "2,1" how to show with a formule the following result;

John,Apple (seperated by comma)

For example see attachment.


results_by_number.xlsx

Kind regards,

Jeroen

no helper columns

Please Login or Register  to view this content.

Thank you very much!

It works fine.