reverse order of results from array index-match formula

[parras]

Hello Chandooers!
I would like to reverse the order of results returned by an array formula using index match. My index match formula on the liftplan sheet returns values from a given column on the tie-up sheet based on match from the treadling sheet. The values on the liftplan sheet need to be displayed horizontally but in reverse order from that provided by transpose function.
What's the best way to do this?
thanks in advance!

Also is there a way to process all the rows from the treadling sheet to the liftplan at once rather than with separate formula for each row?
Again thanks!

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[parras]

Thanks Nebu! I suppose now that we are fetching individual cells back we no longer need transpose or the array formula. I don't follow why the index cell reference you inserted looks at that reference on the current sheet and not the named range "shafttotreadles" referred to in the array argument to index function.

 

[Nebu]

Hi:
The match part of your formula decides on the column number, since you have eight rows to consider and you already know which column from your match formula, its just the matter of saying excel which row value to fetch in which cell. I just assigned the row number to your formula. Hope this make sense.

Thanks

 

[parras]

Nebu, I took your suggestion and solved my issue as shown in the attached file.
Basically to get what I want I fetch each cell in the liftplan sheet with it's own index match formula, referencing the row number I want from the named range "shafttotreadles"array.
What this does is convert treadling and tie-up instructions for floor looms with treadles to a harness lift plan for table looms.
Thanks!

 

[Nebu]

Awesome !!!