LookUp multiple cell values and place in a single cell

N

New Hope UMC

I received help on this earlier and the solution did not work, 'cause
I did not explain it well enough. So here we go...
Sheet "Team Breakout"
Cell D:27 is the company name
Column C Column D
Cell C:35 "A" All Teams achieving an "A" score
Cell C:36 "B" All Teams achieving an "B" score
Cell C:37 "C" All Teams achieving an "C" score
Cell C:38 "D" All Teams achieving an "D" score
Cell C:39 "F" All Teams achieving an "D" score

The above represents the layout I need.

The actual data this comes from is as follows:
Sheet "CrewData"
Column A Column B Column C
Company Name "Team" The score

What I need is this:
Cell D35; give me all of the teams achieving an "A" score (which is
represented ">=90%, <=100%") by looking in the at column A (matching
the Company Name in Cell D:27) and column C matching the ">=90%,
<=100%" Score. Cell D35 could then contain up to 85 different numbers

Then repeat the process for B,C,D and F scores appropriately.

Any clues?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup multiple cell values and place contents in a single cell 3
How to do an IF statement that copy data based on a partial match 0
Look Up Multiple Values in a Column based on single Criteria 3
Macro for comparing columns and highlighting matching/differences 13
Sports summary sheet - think I put this in wrong place originally 1
Recent form / Results 0
Create if partial match then copy and paste data from one cell to another 1
Comparing two columns and returning value from another column 1

Top