Returning Cells Based on Values

[Excel_77]

I have two tabs namely "Working" and "Source" but I need to do the following:

1. In the "Working" tab I have a list of unique IDs in column A, I want to match these with Column A of the Source tab which also contains IDs.

2. Once the corresponding ID has been found in the "Source" tab I want to find the value in row named "football" (all rows are across line one).

3. Within the football heading if the content starts with the word "Yes" then I want to return the corresponding value in the heading called "Golf" otherwise I want to return what is within the "football" heading column, can this be done?

Thanks

 

[Marcelo Branco]

Maybe something like this (assumes the headers in Source A1:Z1 - adjust to suit)

Formula in B2 of Working copied down
=IFERROR(IF(LEFT(INDEX(Source!A:Z,MATCH(A2,Source!A:A,0),MATCH("football",Source!$A$1:$Z$1,0)),3)="Yes",INDEX(Source!A:Z,MATCH(A2,Source!A:A,0),MATCH("Golf",Source!$A$1:$Z$1,0)),INDEX(Source!A:Z,MATCH(A2,Source!A:A,0),MATCH("football",Source!$A$1:$Z$1,0))),"ID not found")

M.