Hi,

I'm looking to incorporate a formula into a database I'm building in Excel that returns the identification of a chemical based on it's linear retention index (LRI). Some of these chemicals have the same LRI and the VLOOKUP function only returns one of the chemicals instead of all of them.

Does anyone know of any Excel functions that can return multiple values?

Thanks,

Joe