Hi Phillip,

Am Fri, 22 Feb 2019 22:20:21 -0800 (PST) schrieb Phillip Swanepoel:

select statement and select team member. then display the info on the left acording to the selected info..

edne.co.za/team.xlsx

download the file from he
https://1drv.ms/x/s!AqMiGBK2qniTgeE1psys_3OkyDWARg

The formulas in the info box are array formulas. They must be inserted
with CTRL+Shift+Enter.


Regards
Claus B.
--
Windows10
Office 2016