Search results

Thank you very much for all your help.

Everyday flight numbers have a different fin number associated to them. So, I need the formula to pick up the correct aircraft type.

Thank you for your continuous assistance. I know your time is valuable. I tried your formula and I still get the N/A. I entered flight 1093 with fin number 471. the result should come up as a 321. But it doesn't.

I noticed that when i change the flight number in A2, I get error message

Sorry for the confusion. I have attached another file. I'm looking for a formula/ vlookup to help me out. When I enter a flight number and a fin. I need the formula to pickup the aircraft type. The problem is that some aircraft fins are duplicates. so, i would need to formula to choose the...

Sorry about that, I thought i did. So, If i enter a mainline flight number and enter a fin the is duplicate. the formula should pick up the correct fin number

I have a formula issue, and I need your help. I attached a sheet. In sheet 2 you'll see aircraft reg's and fin numbers in the first two colums. The fin numbers in yellow are duplicates. It only means the fin is a duplicate and not the reg. I need a way to have a formula pick the correct fin...

Is it too much to ask for the formula to plan only one task in the cell? I would like to see one task assigned and the next task to be assigned to the next available and qualified instructor

I see that I did miss adjusting the cell. Thank you, again for the help. I really appreciate it.

Thank you for your hard work. You are correct AL is an instructor. But when I apply the formula to say Jessica that does not have the skill to do pushbacks, but it comes up that she is qualified. Also, on the Master list "LOADER" task runs from April 1 to the 5th. how can we capture that?

Good day, I've been trying to use this formula. The issue is that if I take away a skill. The Master doesn't not update. Example - On Apr 2nd on AL's line it shows cnx. If I take away that skill from him. The task still shows on Apr 2nd

Thank you, again. Is there a way to divide the task between the instructors that have the skills? and can it plan task to run from a set date. Let's say April first we have 8 tasks that start on April 1 and end on April 5th. Can a formula be created to plan that and to separate the tasks?

Good day, I'm looking for help with a formula. I have a bunch of tasks that fall on certain days. I want a formula to plan it onto an instructor that has the skill. Tasks are located on the third tab marked Master List. Sheet2 has my instructor's skills. I currently have to manually plan the...

Good day, I have one more to ask. On the same attachment. If you unhide the tabs, you'll see 3 more tabs. Is there a way to have the tasks & dates populate onto the Master tab and assign it to an instructor? I currently have to manually input that data

Disregard, I was able to change it. Thank you again for your help.

Can we change it around? Can the formula pick up the employees with the X. X shows they are qualified for the task.

Thank you for all your help.

Good day, I have several tasks on Master List based on days. I would like a formula to populate an instructor from sheet1 that has the skills to perform the task