View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peter Peter is offline
external usenet poster
 
Posts: 349
Default Validation List with 2 criterias

Hi there. I want to extract an information with base on 2 columns, like the
example below:

SHEET_1 SHEET_2

A B C D A B C D
1 ee 01 06 11 1 dd 04 09 14 ----- pick-list on
"A1"
2 oo 02 07 12 2
3 uu 03 08 13 3
4 dd 04 09 14 4
5 gg 05 10 15 5

I have in sheet_2 the info on "A1" by validation list (ee; oo; uu; dd; gg)
and when I choose one of that values with a pick-list, for example "dd" give
me the rest (04, 09, 14) to the next cells in that sheet (B1, C1, D1).

Is it possible?

Thanks