Array concept and looping doubt

In attached excel you can find two columns of data where    Column A- Industry Column B- Engine no   In column F you can find the status of engine, here i need to get the status of engine output...