VLOOKUP type query to return multiple values

[chadski778]

I have a list of formulation codes in a column of a spreadsheet and each of them is linked to numerous different saleable products in another column. Is there a function in excel that will return the saleable products for each formulation code, or would I have to build an access database?

Thank you

 

[WinteE]

Try =ARLOOKUP(). You can find this formula on www.excelguide.eu/120/810/120/EN_ARLookUp.html.