I have an array...B15:C30
Column B has names
Column C has initials
I would like a formula that would use a drop down list with each initial from column C and return the name(s) in column B when it matches the initial.
Example:
Drop Down List: MM
B C
John MM
Max IH
Sam MM
Trever RD
Answer Returned:
John
Sam
Column B has names
Column C has initials
I would like a formula that would use a drop down list with each initial from column C and return the name(s) in column B when it matches the initial.
Example:
Drop Down List: MM
B C
John MM
Max IH
Sam MM
Trever RD
Answer Returned:
John
Sam