HPNPilot1200
En-Route
Is there a way to create a list (validation) based off of a column and have other cells populate automatically based on data in the same row as the item you selected from the list? Here is the scenario...
I created a weight and balance spreadsheet but since we have 16 Cirri in our fleet, each has a different empty weight and moment. I would like to create a list for 16 tail numbers and have the cell for empty weight and moment automatically populate. In this example I would like C3 and E3 to automatically populate based on the selection of the list in A3. Thanks for any assistance!
I created a weight and balance spreadsheet but since we have 16 Cirri in our fleet, each has a different empty weight and moment. I would like to create a list for 16 tail numbers and have the cell for empty weight and moment automatically populate. In this example I would like C3 and E3 to automatically populate based on the selection of the list in A3. Thanks for any assistance!