Using EXACT function?

[MIGHTYBOBB]

Hello all.
I have four columns of figures, the first column has a figure on every row.
This figure should be matched in ONE of the remaining three columns unless I've made an entry error.
Can I flag up "TRUE" if this is true and "FALSE" if not?

Like this?

A B C D
1 - 1 - TRUE
4 4 - - TRUE
3 - - 3 TRUE
2 - 3 - FALSE
3 3 - - TRUE
4 - 4 - TRUE

 

[VoG]

Try in E1 copied down

=ISNUMBER(MATCH(A1,B1:D1,0))

 

[MIGHTYBOBB]

Try in E1 copied down

=ISNUMBER(MATCH(A1,B1:D1,0))

Hmm, that seems to work except it throws up a few false "FALSE" results.
I'll have a play and make sure I've not got anything wrong anywhere else.

Thank you!

 

[VoG]

It works with your example data

Excel Workbook
	A	B	C	D	E
1	1	-	1	-	TRUE
2	4	4	-	-	TRUE
3	3	-	-	3	TRUE
4	2	-	3	-	FALSE
5	3	3	-	-	TRUE
6	4	-	4	-	TRUE
Sheet1

 

[MIGHTYBOBB]

Yep, it works fine for me with a little table, just trying to apply to a full workbook is throwing up a problem somewhere.
I'm sure I'm either adapting it incorrectly or somethings interfering with it.
Thanks again.