Lookup based on other cell

**suarezx7** · 02-19-2020, 08:52 AM

Hi,

Any questions give me a shout, many thanks

**ChemistB** · 02-19-2020, 10:34 AM

Try this ARRAYED formula (enter using CNTRL SHFT ENTER instead of ENTER) into B4 copied across and down

Formula:

Please Login or Register  to view this content.

**suarezx7** · 02-19-2020, 10:59 AM

Hi Chemist,
Could you please alter this formula and use 'Aggregate' as i know that works but im not good with writing the formula.

Many thanks

**ChemistB** · 02-19-2020, 11:37 AM

Arrayed formulas should work in Excel 2010 but here is a non-arrayed version

Formula:

Please Login or Register  to view this content.

Re: Lookup based on other cell