S
scottso2000
Any assistance would be greatly appreciated.
I have one cell that uses a Data Validation List drop down box. Th
list of drop down items is Tab Names for other worksheets in tha
book.
I would like to take the results from the drop down and put that into
formula that would reference the tab selected.
Very Basic eg.
Valid Values:
Sheet1 $c$3 = "Blue"
Sheet2 $c$3 = "Green"
Sheet3 $c$3 = "Red"
**********************
Sheet4 Cell A2
Drop Down List: Sheet1
Sheet2
Sheet3
User select Sheet2 (the tab name)
**********************
Sheet4 Cell A3
=(User Selection results of A2) $c$3
**********************
I am trying to get the word Green in cell A3
Thanks,
Scot
I have one cell that uses a Data Validation List drop down box. Th
list of drop down items is Tab Names for other worksheets in tha
book.
I would like to take the results from the drop down and put that into
formula that would reference the tab selected.
Very Basic eg.
Valid Values:
Sheet1 $c$3 = "Blue"
Sheet2 $c$3 = "Green"
Sheet3 $c$3 = "Red"
**********************
Sheet4 Cell A2
Drop Down List: Sheet1
Sheet2
Sheet3
User select Sheet2 (the tab name)
**********************
Sheet4 Cell A3
=(User Selection results of A2) $c$3
**********************
I am trying to get the word Green in cell A3
Thanks,
Scot