Inserting values into a grid

It sounds like a vlookup you need, is it possible to post a zipped copy of your spreadsheet so that one of us can give you a positive answer?

Originally Posted by phil2006

Hi,

I am trying to get scores into a grid. In column A I have the home teams name and in column B I have the away teams name and in C and D I have their respective scores. I then have a grid set up and want to get the figures from column C and D into the relevant positions. To put it more simply I need a function that puts a value in a cell where the two names in column A and B match those on the sides of the grid.

Any help would be appreciated!

Cheers,

Phil

some formulae are just for fun,

=IF(OR(ISERROR(SUMPRODUCT(--($A$11:$A$20=$A2)*(--($B$11:$B$20=B$1)*ROW($B$11:$B$20)))),SUMPRODUCT(--($A$11:$A$20=$A2)*(--($B$11:$B$20=B$1)*ROW($B$11:$B$20)))=0)," ",OFFSET($C$11,SUMPRODUCT(--($A$11:$A$20=$A2)*(--($B$11:$B$20=B$1)*ROW($B$11:$B$20)))-11,0)&" v "&OFFSET($D$11,(SUMPRODUCT(--($A$11:$A$20=$A2)*(--($B$11:$B$20=B$1)*ROW($B$11:$B$20)))-11),0))

others put the scores in.

hth
---

Originally Posted by phil2006

Thanks! That's just what I needed!

Good to see, and thanks for the response.

---
added,

the formula, like the grid, assumes that teams play each other once as Home-Away, and once as Away-Home, and no more than that.
---