O ORLANDO V Jan 30, 2008 #1 Is there an array function that will return multiple results found in a list similar to the way vlookup finds one result ?
Is there an array function that will return multiple results found in a list similar to the way vlookup finds one result ?
K Kevin B Jan 30, 2008 #2 See this page at Chip Pearson's web site. You'll have to scroll down to find the array functions that return arrays. http://www.cpearson.com/excel/ArrayFormulas.aspx
See this page at Chip Pearson's web site. You'll have to scroll down to find the array functions that return arrays. http://www.cpearson.com/excel/ArrayFormulas.aspx
