Link to home
Start Free TrialLog in
Avatar of Pedro
Pedro

asked on

extract wins / losses from other worksheet

Hi everyone,

The attached file contains wins/losses versus a specific team in line 1 of data. For instance, D1 says 'BOS' so B1 and C1 contain the wins losses of BAL (B3) versus BOS (D1).

FYI: all teams in row 1 are changed to reflect the vs team. All teams in row 3 are permanently there to reflect which team the score is for.

What I would like to do is to be able to do this in the sheet named 'Team W-L'. For instance, to populate 'E6' I need to find where 'LAD' (Z3) is located then find all the times it played versus 'CHC' (AB1) and put the wins in E6 and losses in 'F6'.

FYI: D and G columns determine which team is compared to which in the 'Team W-L' sheet. The results from the 2014-2 sheet go in 'EF' and 'HI' for each respective team. The first row of data is manually done to show the expected result.

The other teams should be populated similarly.
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Attachment? :-)
Avatar of Pedro
Pedro

ASKER

Glen,

Am I missing something? i.e. attachment missing?

Pedro
Yes, the attachment is missing. :-)
Avatar of Pedro

ASKER

Glen,

Please post attachment.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Pedrov664 - In your question you quote "In the attached file", Glenn Ray was pointing out that you had omitted to attach a file. How is Glenn supposed to attach the file that you have omitted, it is your file.

Hopefully, Ejgil has made the right assumption regarding the required file in the last comment.

Thanks
Rob H
Avatar of Pedro

ASKER

Rob,

Thanks for pointing that out. You are right the same file can be used.

That said ejgil's formula does work.

Thanks,
Pedro,  If ejgil's solution works, please properly close this thread by clicking the "Accept this solution" link above his post.

This is the craziest thread...
Avatar of Pedro

ASKER

short, sweet and to the point.