Matching/Meeting Criteria From Worksheet to Worksheet

[hammer2]

Hi all,

I need to bring in information from one sheet to another when other criteria has been met beforehand.

Sheet1 is controlled by another program. Col AE and it's cells look for a match from Sheet1 col A cell 5 down to see if there is a match to Sheet 'Selections' in col H, if there is/are matches then Sheet1 col AE will return "Yes" ( or "No" for nil matches as shown).

That part all works well, now what I need to be able to do is when a "Yes" is returned in Sheet1 AE then the VALUE that reflects alongside that applicable return in Sheet 'Selections' col I to be displayed in Sheet1 col S as a 'value'.

Lets do an example....

Sheet1 col A cell 5 has:
1. Ruby Hill
Sheet1 col AE cell 5 returns "Yes" because it found 1. Ruby Hill in the 'Selections' sheet col H.

In Selections sheet col I cell 11 has the value 1...(row 11 is the row that has 1. Ruby Hill)...I need that value in col I cell 11 to now reflect in Sheet1 col S cell 5 because it is the value assigned to 1. Ruby Hill.

The values differ as can be seen for individual matches.

Hoping this can be done. Have attached the example Workbook.

Many thanks.