Limit Number of Structured Reference Results

[c.clavin]

Hi guys, I was seeing if it was possible to limit the number of structured references to 10 (from my column's list of 70).

My structured reference is:
=INDIRECT('VARIABLE LUT'!B6&"[COLOR]")

My returning header column [COLOR] normally returns 70 results, but I'd only like to return the first 10. Is this possible to limit the number of returned results? Thanks!!

 

[Peter_SSs]

Try

=TAKE(INDIRECT('VARIABLE LUT'!D6&"[COLOR]"),10)

 

[c.clavin]

Fantastic, Thank You Peter! It's amazing how powerful Excel can be

 

[Peter_SSs]

You are welcome. Thanks for the follow-up.