New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

FORMULA TO RETURN DROPDOWN LIST OR VALUE

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

FORMULA TO RETURN DROPDOWN LIST OR VALUE

Postby kupper4 » Sat Jan 23, 2016 3:45 pm

I am looking to find a way to return a condition in a cell that would be dependent of another cell.

Where if Cell A1 value is either "EMPTY" it returns a condition in Cell A2 with "NA" or other wise with a drop down list from a data table.

The Dropdown is a list of variables only to be used if the A1 cell value is not "EMPTY"
  • 0

kupper4
Rookie
 
Posts: 1
Joined: Jan 23, 2016
Reputation: 0
Excel Version: Mac 2011

Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 142 guests