Sumproduct or Index, Match to list data from another sheet meeting criteria

[teststrip]

Hi and Help,

Seems simple but after a few days and no joy I cannot resolve to list column A on another sheet that meets criteria. I'll attach.

1. What I need is Sheet TLH column A to list all Flt #'s on the Trips sheet where the Left 3 characters of Captain or Co-Pilot columns = TLH!A1.

2. I need Sheet N943VG column A to list all Flt #'s on the trips sheet where the Left Find to (-) = N943VG!A1.

See attached.

Any suggestions?
Thank you

Test.xlsx

[MarvinP]

Hi teststrip,

This sounds like an Advanced Filter problem to me. Read more about them at:
http://www.contextures.com/xladvfilter01.html or
http://www.excelfunctions.net/ExcelAdvancedFilter.html

You will need to change a few of your row 2 words as you can't have duplicate column headings. You have "Pos" for both Captain and Co-Pilot.

[teststrip]

MarvinP,

Thank you. I'll look into it. New adventure for me.