Dataset A is a list of nearly 1,200 occupations (column A) and a Job Zone Value (column b). Dataset B is a list of 100-150 occupations that are a subset of the 1,200 in Dataset A. I need to append the Job Zone Value from Dataset A to Dataset B when the occupation is an exact match. Example: Dataset A Column A Column B Chemical Engineer 4 If Chemical Engineer appears in Column A of Dataset B then append the value (4) in column B
Solved by K. L. in 18 mins