Hi, I need help coding this, and I've tried doing it in VBA (which is required), and I'm struggling in terms of where to start, and when I have progressed I've been getting quite a few errors. My professor is expecting us to do this with for, else, and do loops along with functions. Any helps is appreciated. Thanks in advance.

Airplane flight performance Develop a code that would determine the best speed for an airplane to fly at to achieve best mission performance. The user can choose between mission of maximum endurance or range. This code will require to have a table-look up feature