Marking Grid Points

**SamuelT** · 11-18-2008, 12:04 PM

Hi all,

I have a worksheet ('Matrix') that has a grid that is 40 rows x 40 columns. On another sheet ('Drivers') I have a two columned table where a user is enters two numbers between (you guessed it!) 1 and 40.

What I'm trying to do is within the grid, have a "Y" appear on the crossing point as denoted by the table. I've tried a couple of experiments with MATCH, but I'm not getting very far.

I've attached an example document to make this a bit clearer and I've coloured the references on the 'Drivers' sheet to correspond to where they should appear on the 'Matrix' sheet.

Sorry if that's a bit garbled. Let me know if you need any clarification.

TIA,

SamuelT

**Andy Pope** · 11-18-2008, 12:12 PM

Name the range Drivers!$A$2:$A$65 as MYROW and
Drivers!$B$2:$B$65 as MYCOL

The in Matrix!B2 use this formula.

=CHOOSE(SUMPRODUCT((MYROW=$A2)*(MYCOL=B$1))+1,"","Y","X")

Copy across and down.
Note that the X is there as row 39 column 15 is in your list twice.

**SamuelT** · 11-18-2008, 12:40 PM

Thanks Andy, that's working a treat. One other related question - is it possible that if besides the MYROW and MYCOL columns there was another one called (let's say) MYNUM which has a number in it - is it possible to put that in instead of the Y.

Note that the X is there as row 39 column 15 is in your list twice.

That'll teach me to use RANDBETWEEN!

Many thanks,

SamuelT