Help with auto filling cells

[cooperconte]

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). Thanks

[#2]

@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)