Help with auto filling cells

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3134490%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EHelp%20with%20auto%20filling%20cells%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3134490%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%2C%20I'm%20very%20new%20to%20excel%20and%20in%20pilot%20training%20and%20was%20trying%20to%20simplify%20weight%20and%20balance%20and%20would%20like%20to%20know%20if%20I%20can%20auto-fill%20a%20weight%20cell%20(red)%20and%20moment%20cell%20(green)%20from%20a%20chart%20when%20I%20type%20in%20the%20Tail%20number(purple).%20Thanks%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-center%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346088i2F3FE02FDA93ADFE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22excel.jpg%22%20alt%3D%22%5C%26quot%3Bexcel.jpg%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3134490%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

Hi, I'm very new to excel and in pilot training and was trying to simplify weight and balance and would like to know if I can auto-fill a weight cell (red) and moment cell (green) from a chart when I type in the Tail number(purple). Thanksexcel.jpg

 

1 Reply

@cooperconte That would be with VLOOKUP or XLOOKUP is you are on a recent version of Excel. In your case the general syntax would be:

=VLOOKUP(tail, planes_table,2,FALSE) for the weight and

=VLOOKUP(tail, planes_table,3,FALSE) for the moment.

 

replace the words "tail" and "planes_table" by cell references or you own named ranges or use structured table references.

 

with XLOOKUP it would be something like:

=XLOOKUP(tail, planes, weight)

=XLOOKUP(tail, planes, moment)