Using Multiple Options to Define Outputs

L

LHP

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!!
 
B

Bernie Deitrick

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

like this

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

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

Similar Threads

Sum a dynamically-defined range 3
Conditional Formating based on Data Validation 3
Vlookup across multiple worksheets 2
Conditional Data Validation Options 2
Merging files with nearly identical values in one column 3
Summing rows using formulas with variables 1
Sorting Madness 5
group/ungroup column/row buttons 5

Top