if formula that points to a cell with a drop down

		Microsoft Office Forums > Microsoft Excel > Excel
if formula that points to a cell with a drop down

FAQ

Mark Forums Read

Thread Tools

Display Modes

02-07-2014, 07:18 AM

bremen22

Windows 7 64bit if formula that points to a cell with a drop down

Office 2010 64bit

Advanced Beginner

Join Date: Jul 2013

Posts: 44

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula in cell b1 using cell a1 if a1 is over certain number	pumkinbug87	Excel	5	12-03-2013 12:34 PM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
Edit Points in Curve: MS Office changes points properties itself, without my action.	Sergey SPb	PowerPoint	0	08-27-2012 05:33 AM
Chosen option of drop-down changes another cell content	Weed	Word	1	01-26-2012 02:44 PM
Drop down box in a cell	Grapejuice	Excel	0	10-22-2007 07:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:50 PM.