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))

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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