Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Multiple Outputs of a Single Cell | Excel Discussion (Misc queries) | |||
multiple inputs, multipul outputs (part 2) | Excel Discussion (Misc queries) | |||
multiple inputs, multiple outputs | Excel Discussion (Misc queries) | |||
Using solver with function with multiple outputs | Excel Worksheet Functions | |||
Define inputs and outputs to make functions from sheets | Excel Discussion (Misc queries) |