Validation options

numberonetwin

New Member
Joined
Jul 24, 2007
Messages
49
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?
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

ExcelChampion

Well-known Member
Joined
Aug 12, 2005
Messages
976
=IF(A1="LIGHT","DARK",IF(A1="DARK","LIGHT",""))

Assumes your validation is in cell A1.
 

numberonetwin

New Member
Joined
Jul 24, 2007
Messages
49
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

Well-known Member
Joined
Aug 12, 2005
Messages
976
What is the cell address of your validated cell?

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

numberonetwin

New Member
Joined
Jul 24, 2007
Messages
49
C66 for the selected item and have the non selected item move to B71
 

ExcelChampion

Well-known Member
Joined
Aug 12, 2005
Messages
976
Try to follow this example:
Book1
ABCDE
1ListValidatedCellFormula
2johnjohnbob
3bob
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!
 

Forum statistics

Threads
1,181,658
Messages
5,931,272
Members
436,786
Latest member
Deniel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top