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:
Help Article Resources
Check out the Formula Handbook template!