Data validation and Arrays

R

Ricardo Lopes

When entering the following formula as an Array it works. But adding the same
formula to Data Validation, it displays an error. The same common error when
you enter a wrong formula in the List option.
However, if I use a cell reference instead of a table reference (not range),
it works either with the Array and the Data Validation.
This formula works for both
=OFFSET(rngStart,MATCH(tblAccount[Type],rngColumn,0)-1,1,COUNTIF(rngColumn,tblAccount[Type]),1)
This formula works for the Array only:
=OFFSET(rngStart,MATCH($C$3,rngColumn,0)-1,1,COUNTIF(rngColumn,$C$3),1)

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP & Data Validation 0
Drop down list from index/match formula 1
I need help with this. 2
Data validation error with multiple CPU 3
Mapping integers to strings 6
Data Validation Help Needed urgently !!!!!!!!!!! 17
Validation List 0
UPDATED - How to multiply arrays and get the largest number in theresulting array ? 4

Top