Validation List with 2 criterias

P

Peter

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
 
T

T. Valko

Try this...

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

Copy across as needed
 

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

Top