Hi all,
Been struggling with this for a while (first time post-er as well).
I have a column of numbers with multiple numbers in each cell (75, 82, 82, 85, 18) and a table which matches those number with what those number refer to. ( 75=Networking, 82=Security, etc.)
I need to replace the column of numbers with what the numbers equal to while keeping in mind the commas in that cell as well.
It sounds easy but its a tricky one.
I have att a sample sheet.
Any help is appreciated!
test data.xlsx
Bookmarks