LOOKUP help for data in separate tabs

Hi everyone,

This is my first post on the forum, but I've seen how helpful the members have been to others' problems. Hopefully this one will be a breeze for you.

I have two tabs in a workbook: INPUT and TEAM PAGE

I am trying to search for values in the INPUT tab based on criteria in on the TEAM PAGE tab.

I explained the details in a text box in the sample file attached.

Thanks very much for your help.