Validation options

[numberonetwin]

If you have two values in a list and choose one....can you make the second item automatically go to another box.

Thanks


ie...

LIST
LIGHT
DARK

If you choose dark....can you make light show up in a cell further down the page?

 

[ExcelChampion]

=IF(A1="LIGHT","DARK",IF(A1="DARK","LIGHT",""))

Assumes your validation is in cell A1.

 

[numberonetwin]

Still having trouble.
the reason i ask is b/c i am doing a tournament for a sports pool and the winner goes to the next round but the losers drop to a losers bracket...

do i just paste that formula in the box i want the opposite(loser) to go?

thanks

 

[ExcelChampion]

What is the cell address of your validated cell?

What is the cell address where you want to show the opposite value?

 

[numberonetwin]

C66 for the selected item and have the non selected item move to B71

 

[ExcelChampion]

Try to follow this example:

Book1
	A	B	C	D	E
1	List		ValidatedCell		Formula
2	john		john		bob
3	bob
Sheet1

Formula in E2:

=INDEX(A2:A3,MATCH(TRUE,(A2:A3<>C2)))

Which must be confirmed with Ctrl+Shift+Enter, not just Enter.

Change cell references to suit your needs.

HTH!

 

[numberonetwin]

Thanks Todd

Worked Perfectly!!

Thanks again!