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

Validation List with 2 criterias
 

Try this...

=INDEX(Sheet1!B$:B$5,MATCH($A1,Sheet1!$A$1:$A$5,0) )

Copy across as needed

--
Biff
Microsoft Excel MVP


"Peter" wrote in message
...
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