Microsoft Office Forums - View Single Post - if formula that points to a cell with a drop down

Thread: if formula that points to a cell with a drop down

View Single Post

Old

02-08-2014, 06:22 AM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 8

Windows 8

Kevin@Radstock uses Office 2013

Office 2013

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

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

Reply With Quote