ExcelBanter - array

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - array (https://www.excelbanter.com/excel-discussion-misc-queries/174963-array.html)

ORLANDO V[_2_]

array

Is there an array function that will return multiple results found in a list
similar to the way vlookup finds one result ?

Kevin B

array

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
--
Kevin Backmann

"ORLANDO V" wrote:

Is there an array function that will return multiple results found in a list
similar to the way vlookup finds one result ?

All times are GMT +1. The time now is 09:49 PM.