IF Formula

[daniels012]

Here is my formula:

=vlookup(1,X2:Z6,3,False)

I need to do this formula only if X2:X6 all have a different value. Is there a formula I can use to determine this?

Like if there are values:
X2=1
X3=1
X4=3
X5=4
X6=5
Then the formula would leave the cell blank.

If the value is:
X2=1
X3=2
X4=3
X5=4
X6=5
Then the formula would give the result of the Vlookup formula.

Thank You,
Michael

 

[MrKowz]

Perhaps:

=IF(COUNTIF(X2:X6,"=1")>1,"",VLOOKUP(1,X2:Z6,3,FALSE))

 

[T. Valko]

Here is my formula:

=vlookup(1,X2:Z6,3,False)

I need to do this formula only if X2:X6 all have a different value. Is there a formula I can use to determine this?

Like if there are values:
X2=1
X3=1
X4=3
X5=4
X6=5
Then the formula would leave the cell blank.

If the value is:
X2=1
X3=2
X4=3
X5=4
X6=5
Then the formula would give the result of the Vlookup formula.

Thank You,
Michael

Here's a generic method...

=IF(SUMPRODUCT((X2:X6<>"")/COUNTIF(X2:X6,X2:X6&""))=5,VLOOKUP(1,X2:Z6,3,0),"")

 

[daniels012]

Thank You both!

Michael D

 

[T. Valko]

Thank You both!

Michael D

You're welcome!