Forum Discussion

Copper Contributor

Dec 22, 2017

Excel Data Validation List Error

Hello, Last mont or so i created an excel with a data Validation like this: =IF($C$2="DAM-1",'Hiden Data'!$B$2:$B$5,IF($C$2="DAM-2",'Hiden Data'!$B$6:$B$8,IF($C$2="DISCO FAN LEAP-A",'Hiden Data...

excel

Formulas and Functions

clamon

Copper Contributor

Oct 18, 2022

IBighouse

I had the same error. It was because i was trying to validate data in merged cells. I unmerged the cells and it cleared the error.

Toya

Copper Contributor

Dec 18, 2024

This is also what worked for me. Excel is reading each cell instead of counting the merged cells as one.