Thread: if formula that points to a cell with a drop down
View Single Post
 
Old 02-07-2014, 07:18 AM
bremen22 bremen22 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Default if formula that points to a cell with a drop down
On sheet of a work book I have column C set up to perform a data validation and users must select from a drop down. I am trying to write an if statement that keys off of what is selected in the drop down.

my formula is

Code:
=IF(C2="A", (Sheet4!J1), IF(C2="B", (Sheet4!J2), IF(C2="C",(Sheet4!J3), IF(C2="D",(Sheet4!J4), ""))))
However i can not see any of the data that has been entered in Sheet 4
Reply With Quote