Help with V-lookup

I have two sheets with the following 2 columns.

column 1 - HRC code

column 2 - status

The HRC code will always match on both sheets but the status may be different. Sheet 1 will have the most current status but sheet 2 may have old information. I want the vlookup from sheet 2 to find the hrc code on sheet 1 and automatically update the status according to the status listed on sheet 1. Is that possible?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!