PDA

View Full Version : [SOLVED] Name Manager question



austenr
07-17-2015, 04:15 AM
I am using a Name Manager to populate a cell with a drop down but when you use the data validation on it and try the drop down all that populates the list is the Name Manager name. My formula is:

=OFFSET(Lists!$D$5,,,COUNTA(Lists!$D$5:$D$7))

p45cal
07-17-2015, 04:58 AM
prefix the Name in Source field in the Data Validation dialogue box with an = sign

austenr
07-17-2015, 07:13 AM
Thanks I got it. Marked solved.