I have two sheets: in the first sheet there's a code that corresponds to a value of the second sheet, how do I replace the code with the value?

First Sheet

Name Last name Job
xxxx xxxxxxxxx 3
xxxx xxxxxxxxx 7
xxxx xxxxxxxxx 5

Second sheet

Code Job 3 xxxxxx 4 xxxxxx 5 xxxxxx 6 xxxxxx 7 xxxxxx

How do I replace the job code in the first sheet with the corresponding job text of the second sheet?

2

1 Answer

You will need in the first sheet a new column, titled for example: Job Name and with the formula:

=VLOOKUP(C2,Sheet2!A2:C30,2,FALSE) 

Explanation of the function VLOOKUP

=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, TRUE for approximate match or FALSE for an exact match).

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy