# INDEX Horizontal to Vertical between Limits

1. ## INDEX Horizontal to Vertical between Limits

in Row 1 : 10 11 12 15 33

(A1=10, B1=11, C1=12, D1=15, E1=33)

I need them in Column F, between 10 and 16
A2=10
A3=16

(F11=10, F12=11, F13=12, F14=15, F15=33)

2. ## Re: INDEX Horizontal to Vertical between Limits

How does this differ in practice from your earlier thread?

https://www.excelforum.com/excel-gen...orizontal.html

3. ## Re: INDEX Horizontal to Vertical between Limits

Use this:

=IFERROR(INDEX(\$A\$1:\$E\$1,ROWS(\$1:1)),"")

4. ## Re: INDEX Horizontal to Vertical between Limits

Or array entered: =IFERROR(INDEX(\$A\$1:\$E\$1,SMALL(IF(\$A\$1:\$E\$1>=\$A\$2,IF(\$A\$1:\$E\$1<=\$A\$3,COLUMN(\$A\$1:\$E\$1)-COLUMN(\$A\$1)+1)),ROWS(\$F\$1:F1))),"")

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1