VLOOKUP Help

I am trying to bring data in from another source sheet. This source sheet is updated as users submit forms. So when a user submits a form with new data, a new top row is created on the source sheet. I would like it to auto update my master tracking sheet. Is this possible with vlookup? The issue is I need it to be specific to the aircraft number. So if a user submits data for N308LC, it updates that cell on the master sheet. The same for the other aircraft numbers. Any help appreciated. Thx.

Source sheet pic:

The issue is I need it to be specific to the aircraft number.

Master sheet pic:


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!