LinkBack URL
About LinkBacks
When I use the match index form, the index formula gives me back only 1 result from 1 column. What if I wanted multiple results from multiple columns. Is there a way to get multiple results without having to enter multiple index formulas?
When I use the match index form, the index formula gives me back only 1 result from 1 column. What if I wanted multiple results from multiple columns. Is there a way to get multiple results without having to enter multiple index formulas?
Index can return multiple results, but only one is visible at a time in 1 cell.
Can you clarify your requirement?
Cheers!
Deep Dave
Hi Thursday,
This sounds like you are trying to discover Arrays. See:
http://www.cpearson.com/excel/ArrayFormulas.aspx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks