How would I match multiple to 1

I have two columns, both with numbers. You can see the example on the attached sheet.

What I want to do is find the one number from the available job categories column that matches the one number in the job posted column. So in this example, I would want it to pull out 856 from the list of numbers in the right column because it matches the one number in the left column, and just keep that one.

So the output I would want, is a column that says “856 is the one that matches”

I would then do a lookup against 856 so I could then do a naming convention. That way someone would know 856=Chef.
job cat example.csv (115 Bytes)

Easy. ;0)

patrick.transform (3.7 KB)

Haven’t used the join function before. will have to look in to it. thanks!

1 Like