Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
displaying multiple results from index/match search
I am using index/match to find something in column B, and then output column C and D. There are typically multiple matches, this is always finding just the first one. My data is sorted in alphabetical order descending based on column B. Therefor all my matches will be one after another...- DragonRe
- Thread
- Replies: 17
- Forum: Microsoft: Office
-
creating arrays from non-neighbor columns
Hello, is there a way (without using VB) of making an array without a column in between? For example I want an array that is column A and column C but *not* column B. I'm using this in conjunction with vlookup. Thanks!- DragonRe
- Thread
- Replies: 8
- Forum: Microsoft: Office
