if formula that points to a cell with a drop down

bremen22 · #1 02-07-2014, 07:18 AM

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

bremen22 · #2 02-07-2014, 08:02 AM

I'm an idiot. As I looked at it more closely I found that my parentheses around the "A" need to be removed.

I need to call it for today

Kevin@Radstock · #3 02-08-2014, 06:22 AM

Or use the LOOKUP function.

=INDIRECT("Sheet4!"&LOOKUP(C2,{"A","J1";"B","J2";" C","J3";"D","J4"}))
Or if you have a table in say U1:V4
=INDIRECT("Sheet4!"&LOOKUP(C2,U1:V4))

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