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
-
Make sure you are following the appropriate steps for creating cross sheet references.
Answers
-
I would suggest something like this:
=INDEX({Source Sheet Column To Pull From}, MATCH(Aircraft@row, {Source Sheet Aircraft Column}, 0))
-
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))
-
You are missing the opening curly brackets before each of the {cross sheet reference}s.
-
Updated:
=INDEX({Flight Activity Report ENDING HOBBS}, MATCH(AIRCRAFT@row, {Flight Activity Report AIRCRAFT}, 0))
Getting closer as now I'm getting an #invalidref ????
-
Make sure you are following the appropriate steps for creating cross sheet references.
-
Paul = jedi
Got it working. Thanks again sir!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!