I am trying to create a drop down list for the section that has the red borders. I'm almost positive it worked before, but now I am getting the error: The source list must be a delimited list, or a reference to a single row or column. I;m losing my mind on this!!! Any feedback would be greatly appreciated.
Welcome to the forum.
Please give cell references - there is no red border visible on Excel for iPad.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I can now see the red border, but I don't see where you have attempted to use that list in a validation. What is the problem with simply referring to the list in column W (which could be hidden)?
I am so sorry, I am new to this forum. Below is the formula used when trying to add a drop down list. Cell P3 was just recently added as a BU (Business Unit) only to try out the equation.
=LOOKUP(2,1/(((COUNTIF($W$2:W2,Turbines[Location]))+($P$3<>Turbines[BU]))=0),Turbines[Location])
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks