I want to use an Excel formula to lookup multiple values, but I'm not able to use INDEX
or SMALL
, rendering most array-formula solutions unfortunately unusable.
An example scenario is below:
1 sheet contains 2 columns. Column A contains non-unique cells Column B contains unique cells In column C, I need to return all cells from B where the adjacent cell in Column A contains the character "A".
How can I do this without using array formulas?