Lookup, verify and return data

I am in need of a formula that looks at a cell in sheet 1 and then locates the a corresponding cell in sheet 2 and returns a status within that row back to sheet 1.

Here is what I had started but keep falling short.

Sheet 1:

Sheet 2:

Formula: =IF(ISBLANK([VIN - Last 6]@row), "", INDEX({Chassis Check-in Range 2}, MATCH({Chassis Check-in, VIN - Last 6}, {Chassis Check-in Range 2}, 0)))

I need Sheet 1 to show the chassis status (Arrived / Departed) shown in sheet 2 based on a matching VIN.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!