DSum? Sumproduct?

[quaziblue]

I have a database with 5 rows and 4 columns. Let's say that the rows are positions on a basketball team in order down 1-5 (PG, G, C, PF, F) and the columns are colleges in order across A-D (UCLA, Michigan, Duke, North Carolina).

Is there a way (without using VBA) that I could search and return the cell value in position B3 based on the conditions that it's a Michigan center? What formula would I use? Please let me know if I need to be more specific. Thanks for any help.

Q

 

[ExcelChampion]

You need to be much more specific. However, with your problem vaguely stated, I can offer a vague solution.

=INDEX(TABLE_RNG,MATCH(POSITION_NAME,POSITION_RNG,0),MATCH(COLLEGE_NAME,COLLEGE_RNG,0))

Try plugging in your ranges in to the above and see if you can't work it out. This is what you need, but getting the ranges right can be tricky to a beginner.