VLOOKUP Help

BMiller828

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:

Paul Newcome

Make sure you are following the appropriate steps for creating cross sheet references.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Paul Newcome

I would suggest something like this:

=INDEX({Source Sheet Column To Pull From}, MATCH(Aircraft@row, {Source Sheet Aircraft Column}, 0))

BMiller828

Paul,

Thanks for the reply. The name of my source sheet is "Flight Activity Report". Getting an #UNPARSABLE error?

Here's what I have.

=INDEX(Flight Activity Report Ending Hobbs}, MATCH(Aircraft@row,Flight Activity Sheet Aircraft Column}, 0))

Paul Newcome

You are missing the opening curly brackets before each of the {cross sheet reference}s.

BMiller828

Updated:

=INDEX({Flight Activity Report ENDING HOBBS}, MATCH(AIRCRAFT@row, {Flight Activity Report AIRCRAFT}, 0))

Getting closer as now I'm getting an #invalidref ????

Paul Newcome

Make sure you are following the appropriate steps for creating cross sheet references.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

BMiller828

Paul = jedi

Got it working. Thanks again sir!

Paul Newcome

Happy to help. 👍️