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

Thread Tools

Display Modes

02-08-2014, 06:22 AM

Kevin@Radstock Kevin@Radstock is offline

if formula that points to a cell with a drop down

Windows 8

Office 2013

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

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

« Previous Thread | Next Thread »

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 12:38 PM.