View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vinod[_2_] Vinod[_2_] is offline
external usenet poster
 
Posts: 72
Default Validation list with array formulaes

Hi All,

Is it possible to give array formulae as source reference for a cell
datavalidation list?

Note: using formulae
Eg: {=IF(UPPER(A1:A10)=UPPER("HN305"),INDEX(A1:A10,ROW (A1:A10)),"")}

ColA ColB
HN305 HN305-1
HN305 HN305-2
HN306 HN306-1
HN307 HN307-1
HN305 HN305-3
HN306 HN306-2
HN306 HN306-3
HN307 HN307-2
HN307 HN307-3
HN306 HN306-4

I tried with this formulae:
=IF(UPPER(A1:A10)=UPPER("HN305"),INDEX(A1:A10,ROW( A1:A10)),"")

When I've give it in datavalidation list soure and clicked on OK button I
got the message "The source currently evaluates to an error. Do you want to
continue?". If I click on YES nothing is dispalyed in dropdown list.

Is there any another logic to be displayed in dropdown which are
corresponding 'HN305'?

Please help me out.

Advanced Thanks,
Vinod