Using Multiple Options to Define Outputs
 

I have 10 sets of data in columns.

How do I get the restult of a validation list to select different colums
with a fixed row?

And the same again but wilth a fixed column and different row?

And finally how do I get the two two function together.

i.e list one decides what column and list two decides which row!!

Using Multiple Options to Define Outputs
 

=INDEX(LIST,MATCH(to decide row),MATCH(to decide column))

like this

=INDEX($A$1:$J$1500,MATCH(M1,$A$1:$A$1500,FALSE),M ATCH(M2,$A$1:$J$1,FALSE))

--
HTH,
Bernie
MS Excel MVP


"LHP" wrote in message
...
I have 10 sets of data in columns.

How do I get the restult of a validation list to select different colums
with a fixed row?

And the same again but wilth a fixed column and different row?

And finally how do I get the two two function together.

i.e list one decides what column and list two decides which row!!