2 dimensional formula to return True False

[ac3100]

I have rows of lists as follows:

List Name.........Size 1 Size 2 Size 3 Size 4......
BOOTSJR .........24 cm 25 cm 26 cm 27 cm
BOOTSSR .........27 cm 28 cm 29 cm 30 cm
SKISJR.............102 cm 107 cm 112 cm 117 cm
SKISSR.............177 cm 182 cm 187 cm 192 cm

I have a grid that displays the List Name across the Top and the actual size down the left hand side:

.............BOOTSJR.......BOOTSSR.......SKISJR.......SKISSR
23 cm.....X
24 cm.....X
25 cm.....X
26 cm.....X
27 cm.....X.................X
28 cm........................X

I would like to put a formula in the grid to return an "X" when the condition of size list and actual size are met.

Thanks!

Andy

 

[Saagar]

Though not a 2-dimensional formula, you should be able to achieve what you want with "Countif" function.

 

[jasonb75]

Excel Workbook
	A	B	C	D	E
1	List Name	Size 1	Size 2	Size 3	Size 4
2	BOOTSJR	24 cm	25 cm	26 cm	27 cm
3	BOOTSSR	27 cm	28 cm	29 cm	30 cm
4	SKISJR	102 cm	107 cm	112 cm	117 cm
5	SKISSR	177 cm	182 cm	187 cm	192 cm
6
7		BOOTSJR	BOOTSSR	SKISJR	SKISSR
8	23 cm
9	24 cm	X
10	25 cm	X
11	26 cm	X
12	27 cm	X	X
13	28 cm		X
14	29 cm		X
15	30 cm		X
Sheet1

 

[ac3100]

Beautiful.

Thank you so much.

Andy