i am so so sorry.. i uploaded wrong file... (very similar though the correct sample is available now.... (standing red faced and apologetic)

edne.co.za/team.xlsx

thanx a million


On Saturday, February 23, 2019 at 9:47:57 AM UTC+2, Claus Busch wrote:
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