•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What formula(s) would I use to populate a cell depending on the info of an adjacent cell?
Our take
If you want to auto-populate the plane type based on the tail number in your Excel logbook, you can achieve this using the VLOOKUP function. By creating a separate sheet with a matrix of tail numbers and their corresponding plane types, you can streamline the process. When you enter a tail number, VLOOKUP will search for that number in your reference sheet and return the related plane type into the adjacent cell. This method simplifies data entry and enhances your logbook's efficiency.
So I have an excel logbook and I want to make it so that when I add a tail number, it auto populates the plane type. is there a way I can do that? I was thinking an IF formula? but I am not proficient at excel at all and I am not exactly sure what to search for so I can figure this out. attached is a picture. If I type in C472, I want B472 to automatically fill in the type of plane. it seems I can make a separate sheet with the tail numbers and have it auto populate that info?
I have 5 different types of planes and each type has at least 3 tail numbers. so its like a mini matrix table and idk what to do.
thank you in advance!!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience